Hi everyone, I'm new to the forum and I have limited experience with excel macros. Working on trying to automate our accounts statement process where we take the output of our acounting system (where the data for all accounts are lumped together), and extracting the information for each account so that we have one statement per account.

I've been able to delete blank rows and put all account numbers into another spreadsheet so that I know how many statements are needed for processing. I now have to be able to put the account numbers into each spreadsheet so that we can do a vlookup in the customer database to pick up the addresses as well as look at the original output file to also pick up any transaction lines associated with the account.

I have all account numbers in one column on one worksheet and am able to automatically create a new worksheet (which is in the statement format that we want to create) based on the number of accounts. What I want to do now, is enter each account number in the first worksheet and populate the multiple worksheets with each account number. I need to be able to loop down the column on the first worksheet until I come across a blank row and for each row, populate one worksheet (in the same workbook) and then the next and the next until we get to the last worksheet. See below:

In one column I have multiple account numbers:

123456
245678
341875
567890
567894
123457

In the same workbook, I've already created 6 worksheets (based on the above number of accounts) named Statement (1), Statement (2) to Statement (6). I need to be able to create a macro to take each of the account numbers from the first worksheet and add them to the same cell in each of the 6 worksheets that are in the same workbook.

Does anyone have some "simple" code that I can use that is very easy to understand? Hope to hear from someone soon.