+ Reply to Thread
Results 1 to 1 of 1

Trying to create a new sheet based on column headings selected

  1. #1
    Registered User
    Join Date
    12-06-2012
    Location
    El Paso, TX
    MS-Off Ver
    Excel 2007
    Posts
    14

    Trying to create a new sheet based on column headings selected

    I am trying to create a report of my data by being able to select the column headings that I want and then it being generated on a new sheet from the click of a button. Right now I have created the two reports that I want by hard coding them with formulas that just show the data from the another sheet. I would like to add some flexibilty to my worksheet that allows me to change the columns or order of the columns if possible. I would like it to look like the print comments page or the print 8.5. I think that I should be able to do this with some VBA code, I am just not sure how to do it. I have started a very basic code in module two of the attached worksheet. Assistance on this matter would be greatly appreciated.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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