Please attach a sample workbook to overcome the following issues;

Quote Originally Posted by iuliamihaela View Post
I have an excel file that is being exported everyday, and the columns are either moved or more columns are added.
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?

Initial columns order as per today: A B C D E F DSPID AssortID SKU SKUDescription Quantity ProjectName / Order
Please don't mix column labels (Excel defined) and Column Headers (User defined) when trying to explain an issue.

always needed: A B C D E F DSPID ProjectName AssortID SKU SKUDescription Quantity.
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, Quantity
I have to "read" the headers of the columns and where it says "ProjectName", to move that whole column to B.
Are we just moving the column ProjectName/Order to Column 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.