I have a workbook (Req_PO_Log_V2.xls) that has all of the expenditures for our repair and maintenance funds from our current FY. The lay out is as follows:
| Date | Req Number | Acct | Vendor # | Vendor Name | Description | Cost |
The data I need to be able to split up into smaller worksheets is the Account (
The end result would be several worksheets with the entire rows of information pertaining to each individual acct name (R & M, Op Sup, Well R & M, etc.) that would update every time I enter in new information or via a button running the script. Preferably all in the same workbook.
I have tried other code that I have found on this site but get instances of multiple workbooks created with only 2 or three lines for each account (the spreadsheet has a few hundred lines) and then being asked if I want to over write the workbook that was created.
I have a mild knowledge of how VB works, enough to edit existing code but not to write my own. Any help would be greatly appreciated.