Hi
I need to add the text that is in workbook 1 (highlighted in yellow) underneath each row of workbook 2
Does anyone know a simple way to do this please
Thanking you for your help in advance
Hi
I need to add the text that is in workbook 1 (highlighted in yellow) underneath each row of workbook 2
Does anyone know a simple way to do this please
Thanking you for your help in advance
Welcome to the forum.
Which version of Excel are you using?
Do you need this to work with the source workbook closed, or will it be open?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Is this a one time thing or something that has to occur often?
If just once, take your data in Yellow and move it into the same Workbook (just to make it easier) on a new sheet (name it "Copy" and select the range of yellow text and name it "CopyRange" (named range))
For ease of understanding I named the main sheet "Main" and the sheet with the Yellow text to "Copy" so make sure to rename the main sheet to "Main" and the sheet with the yellow text to "Copy" and then run the macro below:
Please Login or Register to view this content.
Last edited by NewYears1978; 06-06-2023 at 01:37 PM.
Hi
Thank you for your reply
It will be using the workbook that I attached all the time but will be using around 5000 lines
I actually use WPS office
Thanking you again for your reply very much appreciated .
Well, did you try the macro and file I attached? It should do what you want. It would need to be modified though if you're running the macro and then adding more data to the same file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks