Not able to get the vba code to take a headerline and add it to each subline based on cond
TESTROBOTNEW.xlsx
In the attachment I have a explained what I want in Sheet named "Explain what I want " and in sheet named "Datafile" I have the input file and in the sheet named "Expected Result" I have what I want he Vba code to make out of the input file.. So fare I have not been lucky and the Chat GPT cannot do it for me either so maybe some expert here in this fora can help me..
It should be simple because I just want the headerline data for each dataset to copied to the Subitemlines
Last edited by Kellogs; 11-15-2024 at 06:22 AM.
Wrong file submitted as only sheet is "IMPDATA" ?
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks for telling me - now I have manage to get the right file uploaded.
Please Login or Register to view this content.
See "Expected Result" to run macro
Take the HeaderdataROW A as a textjoin from B to E with separators = "-"
and copie this to the subdataRow in this case for A and repeat it for B and C
Another Option...
Please Login or Register to view this content.
Last edited by Sintek; 11-15-2024 at 09:48 AM.
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!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks