Copy over new data from 1 workbook to another workbook and vica versa Automatically

Good Day,

New to the forum, hope I will get to explain the problem perfectly:

I have 2 different formated workbooks, one on a network, and one on my own PC.

I want to subtract certain items from one workbook, and insert it on my workbook's table (and vice versa).

So basically B2 from WB 1, has to be copied to C17 on WB 2. But should I change the value on my sheet, it should also change the value on WB 1.

Also need certain items on WB 2 (say perhaps D5), to change values that are blank on WB1.

Keep in mind though, that all changes will be vice versa on the same row. Ex: WB1(A1) -> WB2 (F16), THEN WB2 (F17) -> WB1 (A14)

Then lastly I also need them only to be copied from WB1 if a criteria in a cell is met on a specific row, and then copy it over initially to a blank new row.

Ex:

------------WB1-------------------
WB 1 A B C D
1 LG 11256 M 66HJ55
2 BOSCH 32548 F GM449M * Criteria LG - Column B & D to WB2 A & D (new row)
3 MIELE 21563 L NDK333

------------WB2-------------------
WB 2 A B C D
1 LG 77256 K 66HLL5
2 11256 66HJ55
3

I really hope you can understand this.

Regards

Jedemeyer1

Thank you arlu1201,

Okay, attached are the two workbooks. I need data from WB1 to automatically transfer to WB2, but also if changes are made and new info is entered into WB2, to be tranfered back to WB1.

An example. WB1 should transfer entire rows to WB2 if a criteria is met, like if the criteria is LG, then it will transfer only rows with the word LG in column A. Also, always in a new blank row, with column A on WB2 representing the date it was transfered.

But it will not transfer all the info on the rows. Only certain info on the rows (marked with colours for your benefit). These colours as indicated on both sheets should transfer to their respective areas. Columns like E,F,I,J & K should remain blank. Sheet 2 on each book will show how WB2 will transfer back to WB1. In the same rows which the original data came from.

I know it is complicated but it is a project I would like to accomplish.

Hi again arlu1201,

Do you mean that WB2 will act as a carbon copy of WB1? In that case no.

Only certain data (via criteria/filter) should be copied to WB2 (and changes ofcourse).

WB2 can be a completely clean sheet however at the start, but I only need certain columns of each criteria row to be copied.

The original WB1 has 47 columns, I only need to "see" 6 of them in WB2.

It would be nice to be able to set it that changes I make to the copied columns on WB2, also changes them on WB1.

As an example. We have a network beteen pc's about 200m away from each other. I need to get info from people at another office (via WB1 on my PC), and then be able to fix certain errors on their workbook (WB2), via only changing them on my workbook (WB1)

Again, very sorry for the confusion... Please do not give up, I will be able to answer any questions you throw at me.

Regards

JEDEMEYER1

Hi,

Unique identifier? Do you mean the criteria?

It will be like, all the rows with LG in column A wil need to be copied.

On a side note regarding reverse lookup. I will not necessarily need to change the date copied to WB2 from WB1, but I may need to use 3 or four columns after the row, and it should send that data back to the same row on WB1.

In other words, I need to see the information from WB1 on WB2, then add my notes further down the line, and that should appear for the people using WB1.

Hope this makes sense. Should make it a tad easier.

Hi,

Any ideas yet?

Ok, I have simplified it a bit.

All info in 1 Workbook.

In other words I need only to have sheets update eachother. Sheet 2, 3 & 4 gets all info inserted into Sheet 1, and if I update that data on Sheet 1, it updates the sheet it was copied/taken from.