Hi,
I want to look at sheet 2, sheet 3, and sheet 4 to see if there's an "Open" issue. I'm thinking a Vlookup, but I can't figure out how to look across multiple sheets. Punch List Workbook.xlsx
If the status column is "Open" in any of the sheets, I want all of the information in the corresponding row to carry over to Sheet 1. Does anyone have any ideas?
Use this code. Press Alt F11 in your file. On the left hand side, you will see Microsoft Excel Objects. Right click on it and select Insert-> Module. Copy the code over. Go back to your main page. Select View-> Macros and select the macro to be run.
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks