Hi,
I need help. I have an Input sheet where data is 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 a 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.
Please can you let me know how to do this basis a code or marco?
I need help. I have an Input sheet where data is 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 a 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.
Please can you let me know how to do this basis a code or marco?