Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help With Formula and Macro Please
I have a worksheet I have named "log" as the first tab of a workbook. It
logs data entered in the same cell from numerous worksheets that follow it. It looks like this: =IF('1'!$C$21<"Brief description of item for log on this line only.",'1'!$C$21,""). Where '1' is the name of the worksheet, the worksheets I want to get the cell info from range in progressively in name from 1 to 134. When I copy and paste the formula within the log, the '1' stays in each formula. I need it to progress 1 digit for each row that I paste the formula into. To change these manually would take me forever. What would be the macro to do that automatically? Any help would be greatly appreciated. I have messed around with macros a little, but don't do it often enough to be proficient. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro formula help | Excel Worksheet Functions | |||
How do I add a formula to a macro? | Excel Discussion (Misc queries) | |||
Formula or Macro Help | Excel Discussion (Misc queries) | |||
Formula in macro help | Excel Programming | |||
Sum Formula in Macro | Excel Programming |