Title range only selects one row, need it to select multiple.
https://www.extendoffice.com/documen...on-column.html
Basically this code that i found splits cell rows into new worksheets based on unique data in the first column.
However, when i select my title range it only ever copies over the first row in the title range.
So, if i change title range to
Please Login or Register to view this content.It would actually only do 'A1:C1'.Please Login or Register to view this content.
Any ideas how to sort this?
Thanks,
Liam
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Re: Title range only selects one row, need it to select multiple.
Ok here's an example sheet. As you can see, from the titles i wish to copy on all sheets only the first row is copied over.
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Quality solution, gave you rep.
Thanks a lot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks