Linking A Workbook To A Master Workbook

[gaspower]

Hello,

Need a little help with linking Workbooks. I have several Workbooks that I am linking each to their own sheet in a Master Workbook. I have this part down and if I change anything in the original Workbook that was originally pasted in the Master, it will updated to that sheet in the Master. Were I seem to be having the issue is if I add a new row in the original Workbook, it will not create the new row in the Master? Seem to be only updated the original paste. How do you get new rows or columns to show in the Master?

Thanks JR

[gmr4evr1]

Try this in the ThisWorkbook section of VBA..

Please Login or Register  to view this content.

The 1st code basically tells it to update the workbook when it opens then it calls the 2nd code. The 2nd code will update any rows that have been added.

[gaspower]

Hello,

My apologies. I did not get a email saying there was a answer. I will try it and let you kno

[gmr4evr1]

No problem