davidmichael99
New Member
- Joined
- Nov 1, 2013
- Messages
- 5
I am having issues separating data from one worksheet to multiple worksheets.
DATA: Entering product code onto a master sheet in column A with test results in column B, C, & D.
Example: Master sheet
<TBODY>
</TBODY>
Result: After new product code is entered for that day onto master sheet I would like to press a button that would update the sheet and separate the data into multiple worksheets based on the product code. A sheet for 1540, 2040, and 2021.
Results: Sheet 1540
<TBODY>
</TBODY>
Is this possible to accomplish with excel functions, macro, or would I need VBA? Which would be the best way to approach this issue and where should I start? I have searched to net for examples but Im not really coming up with any results. Maybe Im just not searching for the right keywords. </SPAN>
DATA: Entering product code onto a master sheet in column A with test results in column B, C, & D.
Example: Master sheet
Product | Test1 | Test2 | Test3 |
1540 | 50 | 55 | 58 |
2020 | 19 | 25 | 74 |
1540 | 51 | 54 | 55 |
2021 | 85 | 45 | 17 |
<TBODY>
</TBODY>
Result: After new product code is entered for that day onto master sheet I would like to press a button that would update the sheet and separate the data into multiple worksheets based on the product code. A sheet for 1540, 2040, and 2021.
Results: Sheet 1540
Product | Test | Test | Test |
1540 | 50 | 55 | 58 |
1540 | 51 | 54 | 55 |
<TBODY>
</TBODY>
Is this possible to accomplish with excel functions, macro, or would I need VBA? Which would be the best way to approach this issue and where should I start? I have searched to net for examples but Im not really coming up with any results. Maybe Im just not searching for the right keywords. </SPAN>