Help creating VBA Maco for Excel 2010 for auto-generate large spreadsheet
Posted on 2012-09-19
I'm in a bind and could use a hand. I'm not as familiar with VBA as I need to be, and I'm trying to learn on the fly. I have a daunting work task that I need to automate ASAP. I may have some follow up questions because I'm trying to simplify this as much as possible to understand the basic syntax.
Sheet1 is blank
Sheet2 contains a list of 50 states in column A, and 8 stores in column B.
I need to create a macro that will perform a Do While Loop (or maybe an array?) that will insert the following onto Sheet1:
We may need to add to the states column in the future (e.g. add Washington D.C. or Puerto Rico) so I need to have room to expand that (not for this case, but down the road it will be a button for the user to click and generate a new sheet with the updated information).
I think this will require two Do While Loops: one to go through all the states (column A) and one for the stores (Column B).
Time is critical so I'm offering up 500 pts to the best answer.