hi,

I have three worksheet(CV, AR and Master List) one is master list what Im trying to do is when i update the CV or AR sheet it should be reflect in the master list automatically.

This is based on reference and revision. I try using vlookup, index and match but the problem is when the second submission. I attached the sample of my excel and enter manually the data that will appear in master list.

Thank you

Attached Files

sample.xlsx (22.0 KB, 16 views)