combine worksheets in one file

  • Thread starter Thread starter estim8or
  • Start date Start date
E

estim8or

cannot find instructions to bring multiple spreadsheets into worksheet
tabs and combine in 1 file. should be simple I know...
Dean
 
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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how can I combine multiple worksheets into a single workbook? 5
how do i combine excel worksheets 1
combine worksheets 1
multiple worksheets 1
Combining data from multiple worksheets into one 4
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
excel: combine several spreadsheets into one workbook 6
Collate Worksheets into single workbook 3

Back
Top