+ Reply to Thread
Results 1 to 2 of 2

Importing spreadsheet and automatically removing columns

  1. #1
    Registered User
    Join Date
    06-08-2011
    Location
    St. Paul
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Importing spreadsheet and automatically removing columns

    Ok I have a very basic knowledge of Excel and this question may either sound stupid because it's easy or impossible, but I thought this would be the best place to ask.

    I frequently get large spreadsheets of data from a data service, all with the same columns. However, I use data from maybe half of the columns and rest are just clutter to me.

    My question is: is there a way to save a template(or something similar, I'm really not sure) so that I can open these large sheets and have it only show me the columns I want everytime?

    As it is now, I have to manually delete every column I don't want before printing it out. This wouldn't be a problem except that I need to pass on this duty to my boss and I'm sure he won't want that kind of trouble.

    Some info incase it matters: all columns the spreadsheets include when I receive them are of the same name. the data is different every time so it's not like a work in progress sort of them

    Thanks for any help solving this problem, or maybe even an explaination on why I can't do what I'm trying to do.

  2. #2
    Forum Contributor bentleybob's Avatar
    Join Date
    02-27-2009
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2010
    Posts
    644

    Re: Importing spreadsheet and automatically removing columns

    I would write (or record) VBA code that deletes the unwanted columns and save it in my Personal.xlsb file. I would then add a button to my QAT that runs the code. Then each time you open the new file, hit the button and you're ready to print or otherwise work with the file.

    If you need help with any of these steps, please let me know.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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