Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update Formula Loop
I have a spreadsheet that I am using as a template. My problem is that I
want to be able to change the source that the formulas pull the data from. I used the Macro recorder, but now I have to enter the source path for each column, about 8 times. There has to be a better way, does anybody know? I thoght a Do Until loop might work, but not sure how to write it into the recorded code. Thanks -- RedFive |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
update formula in column when another cell formula is changed | Excel Worksheet Functions | |||
For To / Next loop doesn't update... | Excel Programming | |||
Loop Formula | Excel Programming | |||
update range in For loop | Excel Programming | |||
extract a foldername with a formula-update formula does not work | Excel Programming |