| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I move multiple tabs in multiple workbooks to a master?
I am in payroll. Each person has their own file with multiple tabs or
worksheets dated for each week. Each week I need to move that week's date tab into a master workbook for multiple people. What is an easier way than move or copy when you right click on the individual tab? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I move multiple tabs in multiple workbooks to a master?
The easiest way is to build a macro which will automatically move the sheets
to the master file..If you are looking for a VBA solution let us know --master book name format --individual workbook naming covention --the sheet name format (week) with examples.. If this post helps click Yes --------------- Jacob Skaria "teelee" wrote: I am in payroll. Each person has their own file with multiple tabs or worksheets dated for each week. Each week I need to move that week's date tab into a master workbook for multiple people. What is an easier way than move or copy when you right click on the individual tab? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I move multiple tabs in multiple workbooks to a master?
Hi,
Check this link - http://datapigtechnologies.com/blog/...od-2/#more-585 -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "teelee" wrote in message ... I am in payroll. Each person has their own file with multiple tabs or worksheets dated for each week. Each week I need to move that week's date tab into a master workbook for multiple people. What is an easier way than move or copy when you right click on the individual tab? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I move multiple tabs in multiple workbooks to a master?
Each city gets their own master (where I combine the muliple tabs or
worksheets each week), so I would name them ORL coversheets WE 10-2-09, or HTX coversheets WE 10-2-09, etc. The individual worksheets in each persons workbook are named 9-25-09, 9-2-09, etc. so just dates The workbooks are named by the person or employee, so John Doe, etc. Let me know if you need further information. Thank you so much for your help!! "Jacob Skaria" wrote: The easiest way is to build a macro which will automatically move the sheets to the master file..If you are looking for a VBA solution let us know --master book name format --individual workbook naming covention --the sheet name format (week) with examples.. If this post helps click Yes --------------- Jacob Skaria "teelee" wrote: I am in payroll. Each person has their own file with multiple tabs or worksheets dated for each week. Each week I need to move that week's date tab into a master workbook for multiple people. What is an easier way than move or copy when you right click on the individual tab? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to populate multiple tabs from a master file | Excel Discussion (Misc queries) | |||
| Can i move multiple lines between workbooks | New Users to Excel | |||
| How do I use VLOOKUP to ref multiple workbooks with multiple tabs? | Excel Discussion (Misc queries) | |||
| How can I move multiple linked workbooks between computers | Excel Discussion (Misc queries) | |||
| Combine tabs from multiple workbooks into one | Excel Discussion (Misc queries) | |||
Linear Mode
