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