if cell = criteria copy rows from multiple sheets to new sheet
Please assist? I have a spreadhseet with 72 sheets. (monthly payment made to different employees over 6 years). I need to find all payments made to a specific employee every month for the 6 years. If cell in column c contains a specific word (surname) then copy the entire row and paste in sheet 73 (all rows found in the 72 sheets must be copied).
Re: if cell = criteria copy rows from multiple sheets to new sheet
Upload a sample workbook with some samples worksheet including sample data and your desired results
In order to attach a file Click the Go Advanced button, and click on the Manage Attachments button
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post. For prompt answer, be descriptive, concise, short, direct, and to-the-point.
Bookmarks