VBA - If cells' value match, then copy and paste specific cells.

[kofafa]

PLUMBING FIXTURE & EQUIPMENT MATERIAL LIST UPDATED5.xlsm

Greetings,

I would like some help with developing a code for a button. The button should be able to perform the following task: Extract cells under headers with yellow color from sheets (LT - LAVATORY TRIM, MBT - MOP BASIN TRIM, SHV- SHOWER VALVE, SKT - SINK TRIM, URFV - URINAL FLUSH VALVE, WCFV - WATER CLOSET FLASH VALVE) , when any value in Column M matches a value in Column C of the Summary sheet. The extracted cells should then be pasted under matching headers colored yellow in the summary sheet in the appropriate row.

Thank you in advance for your help.

 

[kofafa]

hello
I was wondering if you could give me some feedback on something. I'm just wondering if my desired goal is achievable or if there's a better way to approach it. Thanks so much!

 

[kofafa]

Hello, Could someone please help me with this?

Thanks