Zach
Member
Ok VBA Gods, I've got a puzzle for you.
The attached file is a budget vs bid template that my company uses. Currently they manually type all the information in both the budget and actual columns, create new rows for each plan, and adjust the average formulas so they make sure they always include all the information.
What I'm looking to do is on the data sheet; let them fill in the high level information that is basically needed at the top of each set of columns and create a macro that creates the columns (with the formatting) and has it populate the information in the correct places.
I used the Macro recorder to create a crude version of a "copy & paste" macro on tab VBA test 1, but if the data sheet has 5 plans I want to just be able to create 5 columns, if the sheet has 10 plans I want to be able to create 10 columns.
To me it seem like it's a very intricate process but I'm not a wiz at this stuff yet so I didn't know if anyone had any advice for efficiently improving the process out of this manual nightmare!
The attached file is a budget vs bid template that my company uses. Currently they manually type all the information in both the budget and actual columns, create new rows for each plan, and adjust the average formulas so they make sure they always include all the information.
What I'm looking to do is on the data sheet; let them fill in the high level information that is basically needed at the top of each set of columns and create a macro that creates the columns (with the formatting) and has it populate the information in the correct places.
I used the Macro recorder to create a crude version of a "copy & paste" macro on tab VBA test 1, but if the data sheet has 5 plans I want to just be able to create 5 columns, if the sheet has 10 plans I want to be able to create 10 columns.
To me it seem like it's a very intricate process but I'm not a wiz at this stuff yet so I didn't know if anyone had any advice for efficiently improving the process out of this manual nightmare!
