bmarquez74
New Member
- Joined
- Sep 27, 2013
- Messages
- 3
on a daily basis I have lots of data that needs to be separated into various tabs. Example data below:
<tbody>
</tbody>
Based on the contents of the 3rd column, I need the whole line moved to a new spreadsheet within the workbook. For instance, if column 3 data is '4', I need both of those lines moved to another spreadsheet.
<tbody>
</tbody>
Is this possible? Ideally, I would like to have a macro that I can run to move all the data.
1 | a | 3 | f | FEF |
2 | a | 4 | f | DFG |
3 | a | 5 | f | RET |
4 | a | 3 | f | FGH |
5 | a | 7 | f | ERT |
6 | a | 3 | f | DFG |
7 | a | 4 | f | ERT |
8 | a | 3 | f | DFG |
9 | a | 6 | f | DFG |
10 | a | 3 | f | ERTY |
<tbody>
</tbody>
Based on the contents of the 3rd column, I need the whole line moved to a new spreadsheet within the workbook. For instance, if column 3 data is '4', I need both of those lines moved to another spreadsheet.
2 | a | 4 | f | DFG |
7 | a | 4 | f | ERT |
<tbody>
</tbody>
Is this possible? Ideally, I would like to have a macro that I can run to move all the data.