Posted to microsoft.public.excel.programming

Mike[_61_] Mike[_61_] is offline

external usenet poster

Posts: 9

Easiest way to automate spreadsheet merge?

I have from 2 to 5 worksheets that I need to merge. Eack sheet will contain
column titles in row 1. Each sheet will contain data in columns A-O. The
number of rows is variable and there are no named ranges. The columns will
always be in the same order.

Is there a simplw way to do this? How do I find the range of data on each
sheet?

Thanks
Mike

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Want to automate my football spreadsheet.	Marcos R.	Excel Worksheet Functions	1	October 28th 09 10:45 PM
Automate Merge	John	New Users to Excel	12	February 5th 08 01:40 AM
Easiest way to expand 1 spreadsheet to a workbook of 12.	Shadyhosta	New Users to Excel	2	January 31st 07 07:28 PM
Automate Spreadsheet	Karen	Excel Worksheet Functions	3	February 3rd 06 05:57 PM
What is the best (easiest) personal budgeting spreadsheet template	Greyram2500	Excel Discussion (Misc queries)	2	July 30th 05 09:11 PM

All times are GMT +1. The time now is 04:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us