Help with Macro
 

I am trying to create a first time macro and need assistance.

The file I have is .xls and has 3 worksheets. On the worksheet of interest
I need to be able to do the following in this order:

- In columns A to G find all cells that contain a formula and delete sheet
rows.
- Find the last used column (usually J) and select the next column over.
Enter "Qty" in the next cell over (usually column J, row 6).
- After entering "Qty" select the next cell down and enter "1". Fill "1"
down to the last used row.
- Now find the column containing the header "Store#". These need to be
formatted as text and if the number is less than 10 it has to read as "01"
for store 1 and so on.
- Finally save the file as a CSV in a particular location with a file name
derived from the worksheet with the following naming structure "WE mm-dd-yy".

Any help would be appreciated. Also the # of rows changes with each file.
Thanks.

Mike