I am looking for advice on where to begin. I have looked through forums and read the Mr. Excel VBA book but I am not looking to filter any information. What I am looking to do is for the end user to go to the ("Inventory Rpt") worksheet which has headers and columns A:AG, number of rows would vary. I want the vba to select 6 select column from the Inventory Rpt, (selected either by header or by row 2 to end of data in the selected column) tab and copy the information to the end of the data rows and paste in a new tab called "Contractor" in columns A:F with the same headers. What do you suggest as a starting point. Like I said I read some stuff but it talks about filtering the columns first, is this necessary?