Menu

Copy between spreadsheets

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.programming

[email protected] jcrmeyer@gmail.com is offline

jcrmeyer@gmail.com is offline

external usenet poster

Posts: 4

Default

Copy between spreadsheets

Sorry that should have been "move data" not "move date" in my last
sentence!

wrote:
Hi there, I'm a bit of a newbie with macros so was hoping someone might
be able to help me out with this one:

I have a master spreadsheet (master.xls) that has a header row and then
a series or rows containing data in columns A thru G. Each row
corresponds to data taken from a number of other spreadsheets
(order1.xls, order2.xls etc).

Basically I need a macro run in master.xls that will copy data from one
of the order spreadsheets and append it to the rows already there in
master, i.e. find the last row containing data and adding it after
that.

Data in the order.xls workbooks has a fixed format A1:A3 and then a
variable number of rows A5:D5 (A6:D6, A7:D7 etc). So when copied into
Master.xls A5:D5, A6:D6 etc is copied to first empty row in columns D
thru G, and for each of those the same A1:A3 is transposed to columns A
thru C. So it ends up something like this:

A1 A2 A3 A5 B5 C5 D5
A1 A2 A3 A6 B6 C6 D6
A1 A2 A3 A7 B7 C7 D7
etc

I'm okay with opening workbooks, making them active etc. What I need is
the code that will find the first empty row in Master.xls and the code
to copy (a loop I guess) that will move date from order.xls to
master.xls and know when to stop when it reaches the last filled row in
order.xls.

Thanks!

Reply With Quote

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
copy equations between spreadsheets	Greenbeard	Excel Worksheet Functions	2	March 8th 07 04:57 AM
How do I copy spreadsheets with charts?	Helge	Charts and Charting in Excel	2	August 11th 06 12:02 PM
Macro to copy all spreadsheets into 1 spreadsheet	Dtown Dawg	Excel Programming	6	June 7th 06 05:11 PM
Copy range from 600 spreadsheets	Snowsride	Excel Programming	2	February 10th 06 09:43 AM
Copy Spreadsheets	Aurora	Excel Discussion (Misc queries)	1	February 1st 06 04:15 PM

All times are GMT +1. The time now is 07:54 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement