| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to create a new tab based on an existing tab
I have a spreadsheet that is effectively a payroll document it has a main
table with a line for each employee and a tab for each employee which are the payslips and the information feeds from the main table into the tabs, I need to create a macro that will add a new tab (for a new employee) based on the last tab (scructure and functions) but move all the ref functions down one row in the main table, meaning it will pull the details of the latest person added to the spreadsheet. If anyone can provide any insight it would be greatfully recieved. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create new records from existing ones based on 'rule'? | Excel Worksheet Functions | |||
| create named worksheet based on existing numeration | Excel Programming | |||
| Macro to create a new worksheet that is a copy of an existing one? | Excel Programming | |||
| How do I create an excel macro to append to a cell with existing i | Excel Discussion (Misc queries) | |||
| Dynamically create worksheets in Excel based off existing data? | Excel Discussion (Misc queries) | |||
Threaded Mode
