Hi
Need a macro to format a worksheet in excel to 2007 to reflect the following changes:-
1. Clear the contents of row 1 to 6
2. Delete row 1 and 2
3. Delete column A
4. Using Column P scroll down and delete any rows that are blank until end of the worksheet
5. Insert three column to the left of column A
6. Insert the following header in row 4
A: SO/Item
B: PO2/Item
C: Po1/Item
7. Concatenate the Columns A:C as follows:
A: Concatenate date in column G & H
B: Concatenate date in column I & J
C: Concatenate date in column E & F
8. remove concatenate formula in columns A:C - via copy and speical paste function
9. Columns PQR and S copy cut and paste after column C