I have a spreadsheet with multiple groups of data, each with a header row and each group separated by a blank row. I need a macro to copy the header row for each group and paste in column A for each corresponding row below, stop when blank row reached and repeat. See attached file for example. Thanks in advance for any help.
non VBA solution.
dutch => a2=ALS(OF(B1="";B2="");"";ALS(LINKS(B1;2)="12";B1;A1))
english a2=if(or(B1="",B2=""),"",if(left(B1,2)="12",B1,A1))
and drag down.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thread posted in commercial services forum.
Thread closed.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks