Hi all,
I have the Problem that if the word "stop" is not in the table in column J, the VBA copy all data from the table.
In this case it should copy nothing.
Please Login or Register to view this content.
Kind regards,
Thorsten
Hi all,
I have the Problem that if the word "stop" is not in the table in column J, the VBA copy all data from the table.
In this case it should copy nothing.
Please Login or Register to view this content.
Kind regards,
Thorsten
Hi,
Why are you filtering from row 1 and only copying from row 4?
Don
Please remember to mark your thread 'Solved' when appropriate.
I have a table with 6 different keywords in column J (restart, stop, enrolment, Change, cancellation and leaver)
For this I have 6 VBA-Codes to look for the keyword in column "J" (stop in my example) and copy the Ids in column "D" to another worksheet starting in N4.
That does not explain why you filter using row 1 as the header but copy starting at row 4?
oh, you are right. I will change the Range from D4:D500 to D2:D500 and try again
Changing the range will not fix the problem but I wanted to be sure if there was a reason for it before suggesting a solution. Perhaps this will work for you
Please Login or Register to view this content.
It works. Many thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks