Copying Rows of Data to Separate Worksheets

[40022982]

Hello,

I am seeking some VBA help.

On a monthly basis I download a transaction list with thousands of entries.

In this situation I am only interested in what Column A contains. Column A holds the account number. There could be 1000 rows in which Column A would correspond to Account Number 3050 then an additional 1000 rows with Account number 3051 and an additional 1000 rows with 3052 and so on...

I am seeking VBA code which would allow me to quickly move every row corresponding to Account Number 3050 to a separate worksheet within the same workbook. And repeat this process for all Account Numbers in Column A be that 3050, 3051, 3052 3053 etc.

I hope this makes sense. If you require any additional information please don't hesitate to get in contact.

Kind regards,

L

 

[dmt32]

Hi,
Assuming your transaction list has a header row, then give code I posted (post #2) here:https://www.mrexcel.com/forum/excel...t-another-based-value-column-first-sheet.html

a try & see if does what you want

Follow instructions given in post.


Dave

 

[40022982]

Wow.

If I could take you for a pint I would.

You have saved hours.

Thankyou so much!

 

[dmt32]

Wow.

If I could take you for a pint I would.

You have saved hours.

Thankyou so much!

it's a best seller -I get offered many pints for that code but sadly, never had one!

Glad solution helped


Dave