![]() ![]() In the same way that you create Jan, Feb, Mar with Autofill this is a permanent setting for Excel. ![]() The second method is to highlight all the new headings (Country Code, Supp City etc)Ĭlick Edit Custom Lists from General sectionĮscape back to your worksheet and now you can type Country Code and use the Autofill handle to create all the headings automatically. ![]() Semicolon:=False, Comma:=True, Space:=False, Other:=False, FieldInfo _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _ Selection.TextToColumns Destination:=Range(StartCell), DataType:=xlDelimited, _ Here is the Text to column macro that works when the active cell in on the first cell containing te heading Cy.Īpplication.DisplayAlerts = False 'stops the prompt at the endĪctiveCell = "Country Code, Supp City, Supplier, Svc.City, Arri Date, Tour Ref.Site/Bkg, Agent, Nat, Comp Type, Resp., Reason, Profit/Loss Status, Remarks" One is to use a macro that uses Data, Text to Columns and another is to set up a Custom List. There are a number of ways to replace the headings. RE: Excl VBA rename and reorganise header ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |