Hello!
I am trying to create a macro that searches for other a specific value in column C
If value 'VS' has been found (in column C) the values of column C and D need to be copied to Sheet "VS". In column A and C
If value 'LND' has been found (in column C) the values of column C and D need to be copied to Sheet "LND". In column A and C
Hope somebody can help me, made an example file also with how the solution should look like. Hope somebody can help me!
Thanks!!
Last edited by keis386; 11-19-2013 at 11:54 AM.
Maybe:
Please Login or Register to view this content.
Hi,
Wouldn't a pivot table, see attached in column G be a more elegant and simpler solution?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks a lot for your help!
I still have one small question.
I added one column E, if value in same row is 570 values should not be copied,is that possible?
I added an updated excel file
Much appreciated!
Maybe:
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