hello i have this code that it select and copy all cells to the second sheet based on the value "name" and it work perfect
what i need also is to add another value "contact" and also be able to select and copy all the cells based on the "contact" value
can anyone help me with this ?
Scan:
=======
Please Login or Register to view this content.
Last edited by devleb; 12-14-2015 at 04:16 AM.
Not 100% sure what you want help with but you could use Application.CountIf to count the no of occurrences in a range.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Try this
Please Login or Register to view this content.
I'm sorry my english...
i will edit my thread and add the code that i have and this code will select the values in the right of the cells that contain "name" and it work fine
what i need also is to add another value that contain "contact" and also select the values in the right of it
than copy both of them to the second sheet
take a look for the edit thread!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks