Macro or VB code Help on Moving data from one sheet to another Closed

Question

Hello, 
Would request you to please help on the following query I have. I have an Input sheet which has data entered in Column A to F like name, emp id, date etc and I need this data to move in specific cells of a pre formatted new worksheet. I can do this using excel formulas however what I need is that I get one output sheet worksheet created automatically once I enter data in Input Sheet. Lets say I had 20 names in Input sheet , then I need 20 worksheets created automatically one for each person (Same format always) and some cells of Input sheet to be copied in these output worksheet. 
Would be grateful if someone can share his views on how to best do this work automatically instead of manually creating sheets and referencing it.

TrowaD · Answer

Hi DSDaisy,

You start by creating a template sheet of how you want the Named sheets to look like. Call the sheet "Template" and hide it.

Now you write a code which checks if the Named sheet is already there, if not unhide the "Template" sheet, make a copy of it and rename the copy the appropriate Name, hide the "Template" sheet again.
Now you put the correct data in it's correct place.

Think about:
- If you want to keep the data on the Named sheets or if you want to overwrite them.
- When you want the code to run (manually/automatically).
- Handle all entry's at once or one at the time.

Good luck and best regards,
Trowa

Macro or VB code Help on Moving data from one sheet to another

1 response

Similar discussions

Subscribe To Our Newsletter!