Hello vixer
Welcome to EXCELFOX
I only have time to look quickly at this, so I expect I may not fully get to understand exactly what you want.
A working example from you is always helpful for such questions, preferably in the form of sample files with a reduced amount of sample data.
I expect I will not get exactly what you want. But it may be some help. Also, as I do not know your level of VBA understanding , so I am not sure at what level to aim this.
My offering below is most likely not the best way. In VBA we can usually do such things in a large number of different ways.
So, in the absence of any more information from you, I will do a way that just amuses me at the moment!
I like playing with closed workbook references. So in my solution, the only thing that needs to be open is the file
macro.xlsm
The other two data files,
target1.xlsx
target2.xlsx
, will need to be stored in the same folder as macro.xlsm
Finally the file target2.xlsx will be opened to paste in the result.
I use the second worksheet of macro.xlsm, as a help worksheet. ( In my coding I have the name of that worksheet in a variable , strWsm
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://eileenslounge.com/viewtopic.php?f=27&t=35521&p=276185#p276185
https://eileenslounge.com/viewtopic.php?p=276185#p276185
https://eileenslounge.com/viewtopic.php?p=276185#p276185
https://eileenslounge.com/viewtopic.php?p=276673#p276673
https://eileenslounge.com/viewtopic.php?p=276751#p276751
https://eileenslounge.com/viewtopic.php?p=276754#p276754
https://eileenslounge.com/viewtopic.php?f=30&t=35100&p=274367#p274367
https://eileenslounge.com/viewtopic.php?p=274368#p274368
https://eileenslounge.com/viewtopic.php?p=274370#p274370
https://eileenslounge.com/viewtopic.php?p=274578#p274578
https://eileenslounge.com/viewtopic.php?p=274577#p274577
https://eileenslounge.com/viewtopic.php?p=274474#p274474
https://eileenslounge.com/viewtopic.php?p=274579#p274579
https://www.excelfox.com/forum/showthread.php/261-Scrolling-Marquee-text-on-Userform?p=864&viewfull=1#post864
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
Bookmarks