Hello,
I would appreciate some help on a Macro that organizes my columns. The excel files I receive all have column headers and contain below A-P, but the headers may not come in the order as below, meaning A may equal IS_Color, F may equal Title. I would like to have the Macro to arrange columns so they match the order as below, column A=Title, B=Fixed Price etc. Also these column headers all have data below them, so can the corresponding data also be moved to keep same data under the correct header. The rows below the columns headers may range, could be 10 rows, may be 30 rows, so if the Macro can read the amount of data and end with the correct number of rows.
A=Title
B=Fixed Price
C=SKU
D=Cond. Descr.
E=Description
F=IS_Brand
G=IS_Model
H=IS_Color
I=IS_Pattern
J=IS_Original/Reproduction
K=IS_Object Type
L=IS_UPC
M=IS_Main Color
N=IS_Size
O=IS_Service
P=Pictures
Possible one Excel file I may receive, random columns:
Capture_Original.JPG
Below is how I would like columns to arrange, no matter what column sort order I may receive the original file.
Capture.JPG
Thank you very much, JR
Bookmarks