Search for a value in a column and copy row to new sheet for all matching values
I have a button with macro code. When you click the button, it searches for a value in a column and copy the entire row to a new sheet for all matching values.
THIS IS THE MACRO CODE:
The problem I have is that I want the code NOT to copy the ENTIRE row but only up to Column O. Please see attached file as an example...
Please Login or Register to view this content.
Try this on a test copy of your workbook:
Please Login or Register to view this content.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
Brilliant it works 100%!! Thanks very much for the quick response...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks