Load Data automatically when certain criteria meet

[vaibhav2312]

Hello Experts

I have excel workbook containing 3 sheets "purchase order" "Master Data" & " Load Purchase Order"


I want an macro if i will put purchase order no. at " Load Purchase Order" Range "G3" then all data automatically display in to (Load Purchase order)yellow color cells from master data sheet. for further information please refer attachment.

If it is possible then it will be very helpful to me.

Your co-operation / any comment / help in this line will be greatly appreciated.

Thanks in advance
Vaibhav2312

[nilem]

Hi Vaibhav2312, see attachment

[vaibhav2312]

Dear Sir,
Excellent, Perfect, code is Awesome

You are really intelligent person.

Rocking.........

Thank you very much
Reputation added