combining multiple sheets into one

H

HERZHIS

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
 
R

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


HERZHIS said:
I wish I had stayed on top of my VBA, Do you have a Excel function that I
could do
Click to expand...
 
Top