Columns from one sheet to another sheet

[anchuri_chaitanya]

Hi,,

can anyone help me how to get few of the columns which are necessary for my work from one worksheet to another worksheet as in the attached workbook..

if i update in the master worksheet those the columns in the "work" worksheet should update automatically...

would appreciate the help..

Thanks & Regards
Chaitanya

[watersev]

hi, anchuri_chaitanya, please check attachment, hope this helps. Sheet "work" updates on being activated. Hope this helps.

[amarnathp2478]

hi, anchuri_chaitanya, please check attachment, hope this helps. Sheet "work" updates on being activated. Hope this helps.

Dear watersev,

I have a similar task related to this type of copying the whole row from master to another sheet based on condition.

So can u let me know how to create the file.

thanks in advance,
Amarnath

[anchuri_chaitanya]

Hi watersev,

I could not found the one which you have attached is done.. please help me out if i have updated any record in master worksheet, then that record should immediately prompt in the work worksheet... I hope u may..

Thanks & Regards