VBA code to get multiple workbooks to share data by Column

[Lilly]

I really hope someone can help me out. I've seen a couple of sample codes for this but I keep getting an error. This is exactly what I am trying to do.

Workbook 1 (Master log) needs to be able to send data from columns B through J to multiple workbooks (Workbook 2/employee's logs) on sheet 1 of workbook 2 in those same columns and I mean like 20 different ones workbooks eventually. Then Workbook 2 (and all other employee workbooks) needs to be able to send data from sheet 1 Columns K through Q to Workbook 1 (Master log) sheet 2 in columns K through Q as well.

I also need a code to be able to get a code that can do the same type of thing but for rows instead of columns.

If someone can help me out and dumb it down a little since I am pretty new to this and don't speak code yet. ---> () having these blank and expecting me to know what to put in there won't help because I genuinely don't know if something goes in there or not and I wouldn't know what to put.

Thank you a TON to anyone who can help me!

 

[kchiba]

Hi Lilly,

Can you do a mock up of what you want and upload the workbooks.

And explain what data goes from where to where.

kanti

 

[Lilly]

Hi Kanti,

Thank you so much for your response. I have uploaded the dummie documents with the corresponding columns and rows that I am needing to communicate with eachother. I would like the master log to communicate Columns B through J to the Employee log and the Employee log to communicate their portion of the updates (Columns K through Q) to the Master log.

I will also need a separate code to be able to communicate specific rows in the future, but for now just getting this completed will be amazing.

Please note that there will be multiple Employee logs that will send data to the Master log according to specific sheets. for example the Master log will have 20 sheets for each employee, so employee 1's log will send data to the Master log sheet 1.

Hope this helps.

Thank you!