Help to rename column headings and put them it a different order save as new sheet

[gilabrams]

Can someone please help,

I need a VBA to open my spreadsheet file take this data format.
Address City / State / Zip First Name Last Name Email Cell Phone Number


Then rename the headers and put it into this exact format then save it to a new xlsx file name that I can create in the same VBA
UserID City ExpirationDate CHSetIndex FirstName LastName MiddleName Street Zip State HomePhone WorkPhone LastEventLog NeverExpiers Active Deleted GotTransmitters GotCards GotEntryCodes GotPhoneEntryNumbers CustomType1 CustomType2 CustomType3 CustomType4

The UserID needs to Auto number starting with a number that I also input in the VBA

City / State / Zip is all 1 box in the first sheet and I need to separate them into Street Zip State for the new sheet
HomePhone needs to be Cell Phone Number
CustomType1 needs to be the Email
FirstName needs to be the contents of First Name
LastName needs to be the contents of Last Name
Active needs to say TRUE
Deleted needs to say FALSE
LastEventLog Needs show 0
GotTransmitters Needs to say FALSE
GotCards Needs to say FALSE
GotEntryCodes Needs to say FALSE
GotPhoneEntryNumbers Needs to say FALSE


Thank you in advance!

[sandy666]

try here: Excel Programming / VBA / Macros