i have a excel which i have attached to this post, where in raw sheet is the raw data in which i need to insert a column in between A and B and copy the heading of the data against the date, final copy how i want i have attached in the other sheet.
I may be missing something, your attached file July DRAFT.XLS has only one sheet called "Sheet1". Column B has a header called "DOCUMENT DATE". Is that the new column you would like to insert? If yes, how do you derive this column value?