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

25 pts.
Tags:
Excel macros
Microsoft Excel
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Your data sounds very poorly organized. It needs to be in tabular format if you want any chance of being able to solve your problem programmatically.

–JP

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Chippy088
    Lets see if I've got this right. You only need to work with the rows 3,4 and 5 with the result in row 6. Try this (created by using the record macro function.) The only thing you need to change is the value AO6 in the second range select statement to the value in the last last column. It's a quick and simple macro, but it works. You might want to investigate how to make line 3 into a current cell select statement. then you won't need to enter the last data column reference. Sub FillFormulaRight() ' ' FillFormulaRight Macro ' Macro recorded 25/06/2009 by David Wood ' Range("A5").Select Selection.End(xlToRight).Select Range("AO6").Select Range(Selection, Selection.End(xlToLeft)).Select Selection.FillRight End Sub hope this is of some help Dave
    4,625 pointsBadges:
    report
  • Chippy088
    some thing I forgot to mention. Go to the A6 cell, and enter your foumula first, then run the macro. Dave
    4,625 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following