Hi All -
I'm struggling to create a new employee database with limited resources and computer skills.
I'd like to use the information in one main spreadsheet (worksheet 1) to created multiple sheets automatically (worksheets 2-53).
For instance, on sheet 1 there are several rows containing information individual employees. Based on this, I'd like to automatically create individual sheets for each employee on the following pages.
I can link the information on say sheet 2 to sheet 1 but is there a way to do it without manually creating new sheets and entering the formulas for each section.
On sheet 1 (or overall staff summary), there is information for various employees. On sheet 2 there is an individual staff file - i've linked the information from row 1 of sheet 1 to automatically appear throughout sheet 2 . But how can I make this happen for every single employee on sheet 1 (theres over 100) without manually creating each page?
I have the feeling that this is possible but I have no idea how, would greatly appreciate any help!! Oh and I'm using excel 2007.
I'm struggling to create a new employee database with limited resources and computer skills.
I'd like to use the information in one main spreadsheet (worksheet 1) to created multiple sheets automatically (worksheets 2-53).
For instance, on sheet 1 there are several rows containing information individual employees. Based on this, I'd like to automatically create individual sheets for each employee on the following pages.
I can link the information on say sheet 2 to sheet 1 but is there a way to do it without manually creating new sheets and entering the formulas for each section.
On sheet 1 (or overall staff summary), there is information for various employees. On sheet 2 there is an individual staff file - i've linked the information from row 1 of sheet 1 to automatically appear throughout sheet 2 . But how can I make this happen for every single employee on sheet 1 (theres over 100) without manually creating each page?
I have the feeling that this is possible but I have no idea how, would greatly appreciate any help!! Oh and I'm using excel 2007.
