Create a Macro to Copy Columns and Paste in New Workbook

[Closed]
Report
Posts
1
Registration date
Friday October 11, 2013
Status
Member
Last seen
October 11, 2013
-
I have a current workbook and want to be able to paste certain columns in a new excel file if the first column value = upload. The new workbook is a template and the columns need to be pasted in specific columns. For example.

Current workbook column D needs to be pasted on new worksheet in column F

Current workbook column F needs to be pasted on new worksheet in column A

etc.

then save the new worksheet with today's date or some consecutive number or a value on a column in the current workbook.


Current Workbook

A B C D E F
Upload 1223 Red 4 door Nissan ILX
Upload 12546 Green 5 door Nissan ILX
Upload 12587 Black 6 door Chevrolet RDX
6897 Gray 7 door Chevrolet RDX
7888 Green 8 door BMW TL
Upload 6645 Black 9 door BMW MDX
Upload 4444 Gray 10 door BMW ILX