| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data from One Worksheet split into Multiple Worksheets
I have a remittance file data in columns in one worksheet. The data is for multiple vendors some with more than one invoice. An example of the data follows:
Vendor Invoice # Amount ABC Co 1234 $4,300 ABC Co 1235 $2,605 ABC Co 1236 $300 DEF Co 6543 $1,000,321 XYZ Co 123333 $10 XYZ Co 123334 $20 I need to split this data into separate worksheets in the same file so that ABC Co's info is in one spreadsheet, then DEF co's info is in the next etc. Can anyone tell me the Subroutine to make this happen? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split a worksheet into multiple worksheets of the same Excel file | Excel Discussion (Misc queries) | |||
| how to copy data from one worksheet to multiple worksheets at once | Excel Worksheet Functions | |||
| how can I split the worksheet in two different worksheets | New Users to Excel | |||
| How to split up one spreadsheet into multiple worksheets | Excel Discussion (Misc queries) | |||
| split results to multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
