copy a row contents from one sheet to another sheet in a workbook, if certain criteria mee

Hi, I am a new user and have an assignment to complete asap.

My question is how to copy a row contents from one sheet to another sheet in a workbook, if certain criteria meets.

Ok, now clearly, I am working on a asset inventory report with several sheets. Sheet 1 contains master report which tracks various projects with employees name, Warranty , department , type of hardware , etc

Sheet 2, 3 etc. tracks each individual project asset inventory information , warranty , type .

When I enter information in sheet 1, Is there any way to copy information automatically to individual project sheets? By the way we use excel 2003. Any help would be much appreciated, thank you.

Please find the attachment for master data.

Thanks in advance

Thanks for your help , I have downloded file and it work for me.

But i am not able to understand the furmula, i have attached new excel with all sheets where i required data from master sheet like department data, type of asset , warrant / AMC / Replacment data, chargable date ,

Thanks in advance.

Yes please help me in this

Thanks for your help.

Hi Vikas sir,

I have downloded file and check, it is working for Department but it is not working for ohter colum like Cost Type, Type , Expiry Month and Replacement. Data is not moving to respective sheet.

Also i miss on sheet for ME department.

I know i am giving you lotoff truble but i am a new user for EXCEL.

thanks in advance.

Hi Vikas,

Waiting for your suggation.

Hi Vikas sir,
Yes, there is nothing wrong with code.
It is working for department coloum but i required this soulation for more coloum that is mention below

1) Cost Type
2) Type
3) Expiry Month
4) Replacement

Please check if it is possible, thanks in advance.

Hi Vikas Sir,

I am new user in excel, is there any book to learen Micro and other function in excel.