Search account numbers and paste into new column

[cudane]

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

[zbor]

Add in A column this formula:

Please Login or Register  to view this content.

[cudane]

There are different account codes going down, not just 1-2-05/300.

[humdingaling]

Column A

Please Login or Register  to view this content.

hard code

Filter after wards @
Account Code:
Account Total :
Report Total :
to remove the unwanted lines

[zbor]

Didn't notice before.. Here:

Please Login or Register  to view this content.

[cudane]

Sorry to bore you, dark Excel lord. It is not just C3 that needs to be brought into column A but also C9, C13 and C23. Everything below and account code needs to entered until the next account code starts. Look at my 'After' file to see. I tried to drag your formula down column A and it doesn't return the right account codes. I do appreciate the quick reply though. Thanks.

[cudane]

Ah almost! It doesn't seem to work on the last of each of the accounts. For example rows 7,11,21 and 24. Any idea why? Thanks for the help zbor

[zbor]

Put formula in 4th row and pull down.

[humdingaling]

not sure you understand my answer
see attached sheet

hard code results in column A
then filter the unwanted lines which are

Account Code:
Account Total :
Report Total :

[cudane]

brilliant, thank you