combining multiple sheets into one

[Guest]

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

 

[Ron de Bruin]

Hi HERZHIS

You can find a lot of merge examples on my site

 

[Guest]

I wish I had stayed on top of my VBA, Do you have a Excel function that I
could do

 

[Ron de Bruin]

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

I wish I had stayed on top of my VBA, Do you have a Excel function that I
could do