combine worksheets in one file

E

estim8or

cannot find instructions to bring multiple spreadsheets into worksheet
tabs and combine in 1 file. should be simple I know...
Dean
 
R

Ron Coderre

If you're comfortable with VBA (or aspire to be), Ron de Bruin has
website that you might find helpful:
http://www.rondebruin.nl/copy2.htm

If you have a little SQL experience and where the data is structure
like tables, you can use MS Query (and a little SQL editing) t
consolidate, too.

Does that help?

Ro
 
G

Guest

estim8or said:
cannot find instructions to bring multiple spreadsheets into worksheet
tabs and combine in 1 file. should be simple I know...
Dean
Click to expand...
---------------------

If you're only doing this once, not regularly, then I'd just do it
manually. You can open up one spreadsheet, select all the data on the
sheet, and then copy it. Open up your other spreadsheet, insert a new
tab and paste the data onto it.

It may be drudgery, but so is futzing around with code to program some
way to do it automatically.

Good luck...

Bill
 
E

estim8or

Thanks Bill that was my fear... Guess i'll stick to Quattro Pro where
its easy to combine, switch file back to excel when finised to satisfy
my clients.
Dean
 
Top