Link to home
Create AccountLog in
Avatar of Pabilio
PabilioFlag for Spain

asked on

UPDATE WORKBOOK RANGE FROM ANOTHER WORKBOOK WITH CONDITIONS

Hi,

I have a MASTER workbook (attached) which will be filled by User1.
Also there will be a SECONDARY workbook (just the same as the attached one) that will be filled by User2.

The SECONDARY workbook will be send by email from User2 to User1 daily.

I need a macro to Update Range E6:X74 with the following parameters.

If a cell in Range E6:X74 in MASTER is Empty and the same cell in SECONDARY have a value in it (It could be text as well) then MASTER must be updated with SECONDARY values.

If a cell in Range E6:X74 in MASTER has a Value in it and the same cell in SECONDARY have a DIFERENT value it then those cells in MASTER must be highligted in red. (in order that User1 makes a manual check to decide wich value must prevail).

Could you help me please ?.

Thank you in advance for your time.

Regads,
Roberto.
P.S. I have excel 2003 in Windows 7.
MASTER.xls
ASKER CERTIFIED SOLUTION
Avatar of Ken Butters
Ken Butters
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Pabilio

ASKER

Hi Buttersk,

Excellent Code... just as need it.

Thank you very much for your help.

Regards,
Roberto.