Please attach a sample workbook to overcome the following issues;
Which columns are being moved? For example are any of the following columns being moved, DSPID AssortID SKU SKUDescription Quantity ProjectName / Order? Will they always be found within the first 6 columns?
Please don't mix column labels (Excel defined) and Column Headers (User defined) when trying to explain an issue.Initial columns order as per today: A B C D E F DSPID AssortID SKU SKUDescription Quantity ProjectName / Order
Can I assume that the order of columns will always be the same, with the exception of ProjectName/Order which could be anywhere or should we be looking at making sure the order is always DSPID, ProjectName/Order, AssortID, SKU, SKUDescription, Quantityalways needed: A B C D E F DSPID ProjectName AssortID SKU SKUDescription Quantity.
Are we just moving the column ProjectName/Order to Column B?I have to "read" the headers of the columns and where it says "ProjectName", to move that whole column to B.
Can you see where I'm going with this? To attach a file, click on Go Advanced, scroll down to Manage Attachments and follow the prompts from there please. When responding think about the points I have raised here, and we'll be only too happy to have a look at your query.