Dear experts
i have set of range data along with end of splitting values column AA
where values is unique rows get split as different segment header in sheet check
like under column AA no 27 where as text value is split rows data under corresponding segment values header
every segment of splited rows above FY-16 Business Entity Report for the & splitunique value collection,dispute,dues....etc
find the attachment
Hi John
This Code is inModule1 of the attached and appears to do as you require...
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Wow it works sir I do have small change where split columns AA change to AC how to change code if it run on AC column
@ every segment i need two rows down above header i need to update this "FY-16 Business Entity Report for the &" Dispute
Hi John
you had it mostly correct except this line of Code...
should be...Please Login or Register to view this content.
Please Login or Register to view this content.
Amazing Piece of code!!Solved by jaslake greatful to you sir
You're welcome...glad I could help.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks