I am looking for a code that Clears data in column I & J of Destination table, Copies/Paste data from Source only if Support Coordinator is either "Dominque Mitchell" or "Kimberly Sullivan".
Orange table is my desired outcome....thank you
I am looking for a code that Clears data in column I & J of Destination table, Copies/Paste data from Source only if Support Coordinator is either "Dominque Mitchell" or "Kimberly Sullivan".
Orange table is my desired outcome....thank you
There will be more efficient ways of doing this, but the below is written so it's easy to follow.
Let us know if you need any of it explaining.
BSB![]()
Please Login or Register to view this content.
Another Option...
![]()
Please Login or Register to view this content.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
This worked great but didn't want table to resize. How to modify code?
This also worked great but didn't want table to resize.
Why would you want blank unused rows in a Table...?This also worked great but didn't want table to resize.
What happens if Table 1 has more rows than Table 2...?
![]()
Please Login or Register to view this content.
Last edited by Sintek; 08-26-2024 at 11:13 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks