Hello Friends
Could you please help me writing code in VBA for splitting data into multiple sheets?
The split needs to be based on value in one of the columns and the sheet where the data will be sent to should get sheet name same as value in the column. Following data sample may help me explain in a better way:
Following is the input sheet, the data needs to be split based on entry in the column "Job Type".
Following tables are showing data split into multiple sheets and the sheet names are the same as entry under the column "Job Type"
Thanks for your help
Rajesh
Could you please help me writing code in VBA for splitting data into multiple sheets?
The split needs to be based on value in one of the columns and the sheet where the data will be sent to should get sheet name same as value in the column. Following data sample may help me explain in a better way:
Following is the input sheet, the data needs to be split based on entry in the column "Job Type".
Excel 2007 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Invoice Number | Job Type | Invoice Date | Amount | ||
2 | 1234 | Repair | 04-Apr-13 | $200 | ||
3 | 3456 | Contract Work | 10-Apr-13 | $400 | ||
4 | 7896 | General | 23-Apr-13 | $100 | ||
Input Sheet |
Following tables are showing data split into multiple sheets and the sheet names are the same as entry under the column "Job Type"
Excel 2007 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Invoice Number | Job Type | Invoice Date | Amount | ||
2 | 1234 | Repair | 04-Apr-13 | $200 | ||
Repair |
Excel 2007 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Invoice Number | Job Type | Invoice Date | Amount | ||
2 | 3456 | Contract Work | 10-Apr-13 | $400 | ||
Contract Work |
Excel 2007 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Invoice Number | Job Type | Invoice Date | Amount | ||
2 | 7896 | General | 23-Apr-13 | $100 | ||
General |
Thanks for your help
Rajesh