Macro to lookup a value in a Sheet and find that value in another sheet and Copy paste

What are the sheet names? Which cell in sheet2 contains the variable value? In which columns in the other sheet do you want to search for the value? Where do you want to paste all the found rows?

Range B9:K in which sheet, Consolidated_RC or Data? Do you want to copy the entirerow or just from column B to K?

This macro assumes that the Consolidated_RC sheet has headers in row 1 and the data starts at row 2.

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

Last week you have helped me by writing a code for me. The code works great. But I want to make a minor change. Some of the rows and columns in the the sheet CONSOLIDATED_RC I want to protect. (The sheet is protected). When I run the Macro gives me error:
Run-time error '1004'
Unable to set the autoFilterMode Property of the worksheet class.

The protection does not allow the macro to remove the filter. Can you please modify the code to the perform the action on the protected Consolidated_RC sheet. The code is given as under:

Please Login or Register  to view this content.

Thanks in Advance.

Khalid

This macro assumes that the sheet is protected without a password. If you have used a password, please let me know and I will modify the macro.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

My pleasure.