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!!
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!!
