Is there a way to write a Macro that will look at Sheet 1 and look up the value in D3 and see if it is in Columns F to O in Sheet 2 and if there are matches copying and pasting that whole row from sheet 2 onto sheet 1 at A15. After copying pasting all the ones that matched with D3 than starting with D4 and doing the same thing until D7?
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Possibly...
Please Login or Register to view this content.
Thank you so much! Is there a way to add something in the Macro that will create a Pop Up saying "No Requests for this Seat" if it does not find anything in Sheet 2 that matches it?
Your ammended request is not very clear,
I assume that the seat number you refer to is in Cells D3 to D7
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks