Splitting spreadsheet by account number [Closed]

Report
Posts
1
Registration date
Wednesday June 24, 2015
Status
Member
Last seen
June 25, 2015
-
Hello,

I have a spreadsheet with around 500 accounts in. Each account contains a large number of rows of data. I would like to write a Macro so as to split this data down by the account number. Ideally this would then create a new workbook for each account and save it as the account number. Can someone advise if this is possible and assist in creating the macro if so?

Thankyou in advance for your assistance

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!