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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 02:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com