Posted to microsoft.public.excel.worksheet.functions

optimus_1973

Posts: n/a

Copy variable ranges fron difernte shets

Hi:

I have multiple workbook (at least 1 max 4) with a database which varies in
the number of registers (in some cases are 250 in others 450) and i want to:

- Select the range in workbook1 and copy to a consolidate new book then
- Select the range in workbook2 and copy to a consolidate
- Select the range in workbook3 and copy to a consolidate
- Select the range in workbook2 and copy to a consolidate

The previous data must keep.

Can any one helpme with this macro.

Thanks

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
How do I copy formula but only increment certain ranges?	Martc	Excel Discussion (Misc queries)	8	February 4th 10 11:01 PM
Variable ranges	John Contact	Excel Worksheet Functions	1	June 17th 05 08:02 AM
copy ranges from multiple worksheets	simora	Excel Worksheet Functions	2	May 18th 05 01:42 AM
Sum Variable Ranges	Erika	Excel Worksheet Functions	6	December 23rd 04 03:52 PM
Variable Print Ranges	Zshepherd	Excel Discussion (Misc queries)	0	December 2nd 04 03:23 PM

All times are GMT +1. The time now is 10:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us