Hey everyone, I'm a newbie to the sight but like what I've seen so far. I've got a little issue with writing a macro for a sheet. I need to do this every month and the sheet will look a little different each time, i.e. will not necessarily have the same number of lines between under each account number. What I need the macro to do is insert a new column A, find the account code (code in the cell next to cell containing 'Account Code) enter the account code in column A all the way down until a new account begins. I'm making a pivot table of the data so I need to filter by an account code. I'll paste a before and after of an abbreviated version. After.xlsBefore.xls

Many thanks in advance.

Dane