Tom's Hardware > Forum > Applications > Programming > How do I macro 20,000+ series of data?

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

Forum Applications : Programming - How do I macro 20,000+ series of data?

Tom's Hardware: Over 1.4 million members in 6 different countries available to answer all your high-tech questions. Sign up now! Its free!
Word :    Username :           
 

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.

Sponsored Links
Register or log in to remove.
Tom's Hardware > Forum > Applications > Programming > How do I macro 20,000+ series of data?
Go to:

There are 652 identified and unidentified users. To see the list of identified users, Click here.

Please mind

You are about to answer a thread that has been inactive for more than 6 months.
If you still wish to proceed, please ensure that your posting is original and does not duplicate or overlap any prior responses to this thread.

Add a reply Cancel
Sponsored links
  • Ask the community now
  • Publish
Ad
They won a badge
Join us in greeting them