Shifting last column in a range of data to a new column in a new spreadsheet

[Bigred251]

Hello - I have data in Columns A:F in my original spreadsheet and have a macro that, when executed, will copy that same data and place it in those same columns in a new worksheet. What i'm looking for is to have columns A:E be copied into the new worksheet the same as it appears in original, but have the data that appears in column F in the original be displayed in Column J in the new worksheet.

In other words, columns A:E will be identical in the original and the new worksheet, but column F from the original will appear in column J in the new worksheet.

Only the code for the column adjustment is needed.

This is Excel 2010 on a PC.

Thanks in advance for your help!!

 

[igold]

Post the code and we can help you make the necessary changes...