Ok here goes I need a VBA to look at A1 for a value doesnt matter whats in there and to search in a different sheet in Column A for what ever value is in A1 and copy the row and then paste it in a new sheet.
Thank you
Ok here goes I need a VBA to look at A1 for a value doesnt matter whats in there and to search in a different sheet in Column A for what ever value is in A1 and copy the row and then paste it in a new sheet.
Thank you
Last edited by awagenhurst; 12-07-2012 at 03:24 PM.
Hello awagenhurst. Try the following code. It assumes that the first row in Sheet2 and Sheet3 contains the column labels.
Please Login or Register to view this content.
Dude you rock!!!!!!!!!!!!!!!!
Glad it worked out!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks