auto upatated in Master file

[pallu]

Hi

when input file change data should update automatically respective field of in Master file. refer the attahcment file for your reference

 

[pallu]

hi
any updation on this

 

[vijay.vizzu]

Dear Pallu..

Your question not so clear... as per question, if you want to update the input sheet details same as in master sheet .. then u can link all the cells with master file... by putting = along with refer cell like =INPUT$A$1

or you want some different.. then please try to elaborate more..

 

[pallu]

input sheet column row is different in master sheet, it should change based on emp code and headings wise, need higlighted in the master data . master data is contians large no but input sheet is one or two only

 

[Somendra Misra]

Hi Pallu,

Can you clear one thing, when you say input file & master file, are these two different workbooks are they are two different sheets (as in your sample) in one workbook?

Regards,

 

[pallu]

Hi
it is two different sheets only

 

[vijay.vizzu]

Dear Pallu

Please confirm the below flow

EMP Code need to be searched in Master sheet. If found, then as per the header title (Column Name), master data should be updated. If not found, a record need to be add in the master sheet along with the details.

Is this flow right...???

 

[pallu]

yes correct