Okay,
I will do my best to explain this, I can only go into so much background since it deals with confidential information -
Side Note: If all you are going to provide is some sort of negative comment please don't waste my time.
- I have a data sheet with a list of names, ages, salaries, bonuses, etc.
- I have a master variable table that lists calculation variables/percentages pulled into a template based on the specific person's demographics of age and so on.
- I have a template that performs all of the calculations based on data pulled from both data sheet and variable table. It uses direct references so that if a variable is changed it will automatically update.
Essentially, I have to create these template calculation sheets for 50+ individuals at a time. I need to create a macro that uses the template and breaks out into multiple worksheets for each person listed in a row of data sheet (column A). Creating a new sheet within the same file per person that performs the needed calculations based on information pulled from data sheet and a master variable table.
What is my best method to get something to:
- Create a worksheet per person in a row of data sheet
- Name the sheet after that person
- Auto-populate the template with that persons information based on columns.
- I need the template of each sheet to keep the direct references to both data sheet and master variable table as some stuff may be changed and they want to see it update all template sheets instantly. (Ex: A change made to a percentage in the variable table)
I just need help with idea of general area to start.
Thanks
Bookmarks