Results 1 to 9 of 9

UserForm Idea Needed For Matching Columns and Changing Headers

Threaded View

  1. #1
    Registered User
    Join Date
    04-23-2013
    Location
    Jensen Beach, FL
    MS-Off Ver
    Excel 2016
    Posts
    41

    UserForm Idea Needed For Matching Columns and Changing Headers

    Hi! I'd like to create a User Form that will change my column headers to be what I need for upload into my database. I'd like the User Form to show me what the header currently is, and then allow me to choose from a list what the upload header should be, and then have a macro replace the original header with the one I chose from the list. Before I went too far, I wanted to see if anyone had any ideas about the cleanest/best way to accomplish this. The original data column headers will be different every time, so I can't simply write something to look for this and change it to that. The user will need to say "this column contains this data". And there could be anywhere from 5 to 50 columns of data on the spreadsheet.

    Any ideas on the best way to accomplish this? My current thought is with two comboboxes one that is populated with the range of row 1 so it shows you all of the original headers, and then the second one with all the proper upload headers to choose from. It seems like there is probably a slicker way to do this and I am hoping someone will have a better idea.

    Thanks in advance!
    Spacle
    Last edited by spacle; 09-30-2020 at 02:40 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 14
    Last Post: 08-04-2020, 12:06 PM
  2. [SOLVED] Idea needed for Car tracking table
    By jp16 in forum Excel General
    Replies: 2
    Last Post: 11-23-2017, 06:36 AM
  3. Allocation of columns to other sheet based on matching headers
    By etaver87 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-24-2016, 09:44 AM
  4. Allocation of columns to other sheet based on matching headers
    By etaver87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2016, 09:41 AM
  5. Replies: 4
    Last Post: 02-08-2014, 02:31 PM
  6. VBA macro needed to delete duplicate entries matching across multiple columns
    By chicolocal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2012, 02:34 PM
  7. Auto filter multiple columns matching with searched headers
    By gotovamsee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2011, 03:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1