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.
Bookmarks