| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
consolidating worksheets into a table
how do i take 2 columms of information 1 being names and the other being
shifts example 6-2 and putting them all on 1 seperate sheet i have 7 sheets 1 for each day.Also the names are not always in the sames colomms or even on the sheet at all.please help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
consolidating worksheets into a table
Since there's only 7 sheets and the names can be in any column, I think I would
just do 7 of these: Select the range edit|copy go to the new sheet (next available row) edit|paste (repeat 6 more times) jourdan 1 wrote: how do i take 2 columms of information 1 being names and the other being shifts example 6-2 and putting them all on 1 seperate sheet i have 7 sheets 1 for each day.Also the names are not always in the sames colomms or even on the sheet at all.please help -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
consolidating worksheets into a table
yes that would be so easy ut yet i have to make it so complicated i need it
to automatically update the information to the new sheet without copying and pasting "Dave Peterson" wrote: Since there's only 7 sheets and the names can be in any column, I think I would just do 7 of these: Select the range edit|copy go to the new sheet (next available row) edit|paste (repeat 6 more times) jourdan 1 wrote: how do i take 2 columms of information 1 being names and the other being shifts example 6-2 and putting them all on 1 seperate sheet i have 7 sheets 1 for each day.Also the names are not always in the sames colomms or even on the sheet at all.please help -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
consolidating worksheets into a table
Maybe you could start by recording a macro when you do it manually????
jourdan 1 wrote: yes that would be so easy ut yet i have to make it so complicated i need it to automatically update the information to the new sheet without copying and pasting "Dave Peterson" wrote: Since there's only 7 sheets and the names can be in any column, I think I would just do 7 of these: Select the range edit|copy go to the new sheet (next available row) edit|paste (repeat 6 more times) jourdan 1 wrote: how do i take 2 columms of information 1 being names and the other being shifts example 6-2 and putting them all on 1 seperate sheet i have 7 sheets 1 for each day.Also the names are not always in the sames colomms or even on the sheet at all.please help -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
consolidating worksheets into a table
Try using "Consolidate", under Data. Look up consolidate data in the help
menu, and follow consolidate by category steps. I just learned this yesterday cause I'm doing something similar. Good luck Barbra "Dave Peterson" wrote: Maybe you could start by recording a macro when you do it manually???? jourdan 1 wrote: yes that would be so easy ut yet i have to make it so complicated i need it to automatically update the information to the new sheet without copying and pasting "Dave Peterson" wrote: Since there's only 7 sheets and the names can be in any column, I think I would just do 7 of these: Select the range edit|copy go to the new sheet (next available row) edit|paste (repeat 6 more times) jourdan 1 wrote: how do i take 2 columms of information 1 being names and the other being shifts example 6-2 and putting them all on 1 seperate sheet i have 7 sheets 1 for each day.Also the names are not always in the sames colomms or even on the sheet at all.please help -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Consolidating multiple worksheets into one. | Excel Discussion (Misc queries) | |||
| Consolidating a Row of data from many worksheets | Excel Worksheet Functions | |||
| Consolidating worksheets | Excel Discussion (Misc queries) | |||
| Consolidating multiple worksheets | Excel Discussion (Misc queries) | |||
| Consolidating entries from multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
