Consolidating files (copy from 1 excel file to another excel file)

**city** · 06-09-2012, 02:09 PM

Hi All,

Is there a way to copy cell values from one excel file to another excel file.
From TrackerTest.xlsm TrackerTest.xlsm to DB.xls db.xlsx after a click of a button. Then it will automatically save the DB.xls.

Also in the event of copying, it will skip another row if it already has a data.

DB.xls db.xlsx
TrackerTest.xlsm TrackerTest.xlsm

**xladept** · 06-09-2012, 04:44 PM

Hi City,

This code works if put in the TrackerTest Mainpage sheet and then assign the macro to your standard button.

(You may want to acquire the habit of ActiveX controls).

Please Login or Register  to view this content.

**city** · 06-12-2012, 10:31 AM

i tried the code. it only copies the first line from trackertest.xlsm

**xladept** · 06-13-2012, 02:21 PM

Hi city,

The macro only transfers data from the selected field row - did you want it to just transfer the whole sheet?

**city** · 06-15-2012, 07:02 AM

Thanks so much for helping me xladept!
I need to copy all cells with values from B:G. .

**xladept** · 06-15-2012, 02:01 PM

Hi city,

The way it works is you select a field from a record on the main page - then click on your button and it transfers the b:g fields to the other sheet - is that what you wanted and is that not what it's doing?