Master and slave workbooks

Is there any way to determine what new rows were added in the slave files like a date field in some column? If not, you will need to add them all and then run a macro to delete duplicate rows.

Would the master be in that network folder?

There is no way to determine new rows.

All the files will be in the same network folder

it's possible but I would still need a way to find all the cells that are tagged in each individual workbook and paste them all into one consolidated tab on the master sheet.

I did not address the duplicate issue. Play this from a backup of your master.

Another method to eliminate duplicates might be to import the data for each slave to a sheet. If each slave has unique id's, you can just eliminate the duplicates after each run of the macro below.

With alot of data, I would recommend regular backups of the master. Put this in a Module. Edit the paths in GetMySlaveData as commented as play it.

Please Login or Register  to view this content.

Hi Kenneth,

Each workbook that I am copying from will not have duplicate info; I just don’t want to write over the info pasted from each workbook. Duplicate info can exist. I plan to "re-run" the master workbook at the end of each quarter so the previous spreadsheet will be wiped out and the new info will replace it.

I am still a beginner in editing macros. Would you be able to help me edit the paths?

S:\Production\Annual Strategies is the folder in which all 13 files are located (12 individual slave files and 1 master file)

Each slave file is named "TYLY-season-category" ex: TYLY-FALL 09-M DENIM

The twelve categories are
M DENIM
M KNITS
M GRAPHICS
M SWEATERS
M WOVENS
M ACCESSORIES
W DENIM
W KNITS
W GRAPHICS
W SWEATERS
W WOVENS
W ACCESSORIES

The master workbook is named "LYTY – Recap"

For each slave workbook I need the “LY DATA” tab to be copied and pasted into the “LY data” tab in the master.

I appreciate everything you’ve advised so far and this may be out of my level of understanding so if it is too complex for me I understand.

Then put all of my code in the master workbook's Module and it should do what you want.

You can go to the link at vbaexpress and drag the SpeedUp module from that workbook to your master. Or, for now, comment out the SpeedOn and SpeedOff lines.

Change this:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

You said all the sheets are sheet index 1 so the names are not important.

While some macros look complicated, some look that way to help avoid errors.

I am getting a runtime error '91'

"object variable or with block variable not set "

when i opened debug the below is what was highlighted

'Close the slave workbook if it was not already open
If slaveOpen = False Then slaveWB.Close False

also if there are two tabs in the slave workbooks and I need to run a separate master file to grab all the info in the second tab what would i change in the macro to pull that information

One tab is this year info and the other tab is last year info. I need the info on seprate tabs but in the same master file

Did you copy all of my code? Option Compare Text, makes it compare text where "Cat"="CAT".

Step through your code with F8 so that you can see what is happening. Hover the cursor over variable names to see what they resolved to.

We can always fix it to do additional tasks but it is best to get this one working first. It is a simple matter.

I copied it exactly, It doesnt appear to be finding the slave workbooks in the folder. Is there something I am missing? do i need to change anything in the individaul workbooks so the macro can define them?

I still hit a runtime error at the same spot when checking with F8

You did not change the FilePath?

If debug is bugging you, add this after the Do:

Please Login or Register  to view this content.

After you play it, it will show the filenames in the FilePath's folder in VBE's Immediate window.

Hi there I need to do the same master slave relation and I've tried this example but keep having the same error reported:

I am getting a runtime error '91'

"object variable or with block variable not set "

when i opened debug the below is what was highlighted

'Close the slave workbook if it was not already open
If slaveOpen = False Then slaveWB.Close False

Any idea on how to solve it?

Thanks
David