| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Loop Macro a variable number of times
From previous work I have established certain facts relating to my data. I
now would like to copy a number of spreadsheets based on these facts and auto populate data from the lead spreadsheet. e.g. Lead Spreadsheet Has field that is "Master" or "False" in G1 And Number of Addtional Records in field B34 Variable number from 1 to 25 Task If G1 = "Master" then copy a group of sheets (Header, Quality, Detail, Variance) the number of times stated in B34 For the first new Header sheet copy value in cell F37 For the next Header sheet copy value in cell F38 and so on until Number in B34 has been reached. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| error when running cut & paste macro | Excel Worksheet Functions | |||
| Counting the number of times more than 1 variable occurs | Excel Discussion (Misc queries) | |||
| Closing File Error | Excel Discussion (Misc queries) | |||
| count the number of times the same number shown | Excel Discussion (Misc queries) | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
Threaded Mode
