Help I need a hero! Advanced Macro open close copy paste etc.

[bemcbride]

I have a master commission sheet that has every salesperson with the invoices they get commissioned on. Each individual also has their own individual spreadsheet that has their information along with some personal targets and other information. In the master commission sheet, I have the individual sheets for each person listed.

I want to write a macro that opens this spreadsheet and copy and pastes (values only) onto the specific tab of the individual sheets. After that it should save and close the individual sheet.

Does anyone know if or how something like that could work or be done? I was thinking I could put the file name location in the Workbook column and that might help the macro...I don't know.

Thank you all for any help or assistance you can provide or suggestions. Yall are awesome.

 

[mumps]

Could you upload a couple more individual files so I can test the macro with more than one file?

 

[bemcbride]

Thank you this works! Can you explain to me key how it works? I f i need to delete a column or add more columns how can i adjust that?

 

[mumps]

Currently, the column with the file paths is column Q which is the thirteenth column to the right of column E. If you add or delete columns, you have to change the number "13" in the code (two occurrences) to match the position of the file path column relative to column E.

 

[bemcbride]

Currently, the column with the file paths is column Q which is the thirteenth column to the right of column E. If you add or delete columns, you have to change the number "13" in the code (two occurrences) to match the position of the file path column relative to column

 

[bemcbride]

That makes sense thank you. I notice when I run the code the individual files no longer recognize the data as being apart of a table so the pivots that work off of it no longer have a reference. Right now I'm going back into the individual files and getting that data we copied over and renaming it as Table1 on all of them. Is there way that when it copies and pastes over it leaves the Table1 name with the copied data?