jetbluebob
New Member
- Joined
- Apr 21, 2016
- Messages
- 1
Hello All,
I am trying to put together a spreadsheet that will be, pretty much automated, after importing data from another sheet.
I am currently able to Sort the Data based of the import to other sheets based on the first column data which for this case is City. But the issue I have, is the new data that was sorted out to the different sheets no longer has a Column List Name. Which sorta puts me a stand still... Is there anyway to create a script to autopopulate the current header in the List Name Header for the Column?
<tbody>
</tbody>
Any help would be greatly appreciated
I am trying to put together a spreadsheet that will be, pretty much automated, after importing data from another sheet.
I am currently able to Sort the Data based of the import to other sheets based on the first column data which for this case is City. But the issue I have, is the new data that was sorted out to the different sheets no longer has a Column List Name. Which sorta puts me a stand still... Is there anyway to create a script to autopopulate the current header in the List Name Header for the Column?
City | CrewID | Full Name | <-- This row 1 - needs to become a Named List Column using VBA so i can use it on the 90 other sheets and it needs to automatically be named based on the Row 1 Value and the length needs to be Dynamic | |||||
CITY1 | 2341234 | John Smith | John@John.com | |||||
CITY1 | 12344123 | John John | john@123.com | |||||
CITY1 | 12341234 | John Smith | John@John.com | |||||
CITY1 | 54353 | John John | john@123.com | |||||
CITY1 | 5623456 | John Smith | John@John.com | |||||
CITY1 | 23452 | John John | john@123.com | |||||
CITY1 | 23452 | John Smith | John@John.com | |||||
CITY1 | 2345 | John John | john@123.com | |||||
CITY1 | 3452354 | John Smith | John@John.com | |||||
CITY1 | 2345235 | John John | john@123.com | |||||
CITY1 | 234524 | John Smith | John@John.com | |||||
CITY1 | 2345 | John John | john@123.com | |||||
CITY1 | 8866 | John Smith | John@John.com | |||||
CITY1 | 565 | John John | john@123.com |
<tbody>
</tbody>
Any help would be greatly appreciated