I have a macro setup to create a helper column and paste a vlookup formula to return wether or not an account number matches on another sheet or not. Now i need the macro to delete the rows that have the matching account numbers but keep the rows that have a n/a where it doesn't match. ANy help?
Please Login or Register to view this content.
Look at notes throughout the code. I could not tell what the result of the VLOOKUP is. If the result is a 1/0 (True/False), or simply when the acct # matches the acct# is returned, and assuming the acct# is in fact a number and not an alphanumeric string, the following should suffice.
Please Login or Register to view this content.
Last edited by AlvaroSiza; 04-19-2012 at 10:41 AM.
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".
The cell format for the helper column is set to general. If a result is matched it shows the account #, other wise it has the #n/a thing. Does this help? WIth the code you gave me it would still not work,. Any ideas what I need to do, I just want it to delelete any row that doesnt end with "#N/A"
Originally Posted by AlvaroSiza
Look at notes throughout the code. I could not tell what the result of the VLOOKUP is. If the result is a 1/0 (True/False), or simply when the acct # matches the acct# is returned, and assuming the acct# is in fact a number and not an alphanumeric string, the following should suffice.
Please Login or Register to view this content.
Try changing this line
toPlease Login or Register to view this content.
Please be as detailed as possible when stating that something 'does not work'. Were there error pop-ups? What was the description of the error? Etc.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