| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combining multiple sheets into one
My boss is afraid of Access, so I have to do my entire database in Excel, I
have 2 sheets that 2 different people will be entering data into, I need these 2 sheets to become one for my boss to review but still have them entering in their indivdual sheets and the data automatically update into the Summary sheet for my boss -- Thanks again, Herz and His |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
combining multiple sheets into one
Hi HERZHIS
You can find a lot of merge examples on my site -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "HERZHIS" wrote in message ... My boss is afraid of Access, so I have to do my entire database in Excel, I have 2 sheets that 2 different people will be entering data into, I need these 2 sheets to become one for my boss to review but still have them entering in their indivdual sheets and the data automatically update into the Summary sheet for my boss -- Thanks again, Herz and His |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
combining multiple sheets into one
I wish I had stayed on top of my VBA, Do you have a Excel function that I
could do -- Thanks again, Herz and His "Ron de Bruin" wrote: Hi HERZHIS You can find a lot of merge examples on my site -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "HERZHIS" wrote in message ... My boss is afraid of Access, so I have to do my entire database in Excel, I have 2 sheets that 2 different people will be entering data into, I need these 2 sheets to become one for my boss to review but still have them entering in their indivdual sheets and the data automatically update into the Summary sheet for my boss -- Thanks again, Herz and His |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
combining multiple sheets into one
How much date you enter in each sheet ?
You can create links to each worksheet cell if you know that. I like to use a macro that with one click create a new sheet with all the data I want. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "HERZHIS" wrote in message ... I wish I had stayed on top of my VBA, Do you have a Excel function that I could do -- Thanks again, Herz and His "Ron de Bruin" wrote: Hi HERZHIS You can find a lot of merge examples on my site -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "HERZHIS" wrote in message ... My boss is afraid of Access, so I have to do my entire database in Excel, I have 2 sheets that 2 different people will be entering data into, I need these 2 sheets to become one for my boss to review but still have them entering in their indivdual sheets and the data automatically update into the Summary sheet for my boss -- Thanks again, Herz and His |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining multiple sheets | Excel Discussion (Misc queries) | |||
| combining multiple sheets | Excel Worksheet Functions | |||
| Combining sheets on one | Excel Worksheet Functions | |||
| Combining data from multiple sheets | Excel Discussion (Misc queries) | |||
| combining data from multiple sheets | Excel Worksheet Functions | |||
Linear Mode
