Home > IT Answers > Development > How do I macro 20,000+ series of data?
Colwyn
25 pts.
 How do I macro 20,000+ series of data?
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.

Software/Hardware used:
ASKED: November 13, 2008  9:57 PM
UPDATED: June 25, 2009  9:22 AM
RELATED QUESTIONS
Answer Wiki:
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
Last Wiki Answer Submitted:  November 16, 2008  2:15 pm  by  JP2112   475 pts.
All Answer Wiki Contributors:  JP2112   475 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

Chippy088
 4,625 pts.
 

some thing I forgot to mention.

Go to the A6 cell, and enter your foumula first, then run the macro.

Dave

Chippy088
 4,625 pts.