The macro recorder is your friend. Do it manually while recording. Then
clean up the macro.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"dbix" wrote in message
...
I've got very little VBA experience, but have created and edited some
Excel
macros.

I will be exporting data weekly into an Excel sheet, and need a macro to
sort and delete some rows. The sheet will have 7 columns with a header
row;
column G will contain a value of 0, 1 or 3. I need to delete all the rows
that are not "1", then will do some other sorts.

the initial export will have up to 400 rows of data.

can someone help with this code?