dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

How do I macro 20,000+ series of data? - Spreadsheets

This is a discussion on How do I macro 20,000+ series of data? - Spreadsheets ; The full s/s stretches to nearly 350,000 rows and consists of over 20,000 series of data, between 6 and 30 rows deep, in columns A:J. In column I of each series, on rows 3, 4 and 5 there are three ...


Home > Database Forum > Other Technologies > Spreadsheets > How do I macro 20,000+ series of data?

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 11-13-2008, 05:58 PM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default How do I macro 20,000+ series of data?

The full s/s stretches to nearly 350,000 rows and consists of over
20,000 series of data, between 6 and 30 rows deep, in columns A:J.

In column I of each series, on rows 3, 4 and 5 there are three
numbers.
The second number is to be subtracted from the first with the answer
being divided by the third.
If possible, the answers should appear in the rows directly beneath
these three numbers.

Because there are so many series of data it isn't feasible to manually
input the formula and I'm searching for a macro(s) which can do it
automatically.

Can anyone please suggest code to help me to this end??
Big thanks.
colwyn.


Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 04:24 PM.