Hello Team,
I have a spreadsheet that looks like this:
<TBODY>
</TBODY>
I will like to split this master into different tabs using column F to look like this:
<TBODY>
</TBODY>
<TBODY>
</TBODY>How can i get this done in excel, is vlookup/hlookup the ideal way, not sure. Please help.
thanks
I have a spreadsheet that looks like this:
a</SPAN> | b</SPAN> | C</SPAN> | D</SPAN> | E</SPAN> | F</SPAN> |
K1</SPAN> | 2/5/2013</SPAN> | SA</SPAN> | AN</SPAN> | 3</SPAN> | OCEAN</SPAN> |
K2</SPAN> | 2/6/2013</SPAN> | GH</SPAN> | ND</SPAN> | 2</SPAN> | LAND</SPAN> |
K3</SPAN> | 2/7/2013</SPAN> | KK</SPAN> | IR</SPAN> | 5</SPAN> | AIR</SPAN> |
K4</SPAN> | 2/8/2013</SPAN> | OO</SPAN> | AN</SPAN> | 6</SPAN> | OCEAN</SPAN> |
K5</SPAN> | 2/9/2013</SPAN> | EE</SPAN> | ND</SPAN> | 3</SPAN> | LAND</SPAN> |
K6</SPAN> | 2/10/2013</SPAN> | QQ</SPAN> | IR</SPAN> | 9</SPAN> | AIR</SPAN> |
K7</SPAN> | 2/11/2013</SPAN> | QW</SPAN> | AN</SPAN> | 3</SPAN> | OCEAN</SPAN> |
K8</SPAN> | 2/12/2013</SPAN> | QS</SPAN> | ND</SPAN> | 0</SPAN> | LAND</SPAN> |
K9</SPAN> | 2/13/2013</SPAN> | DF</SPAN> | IR</SPAN> | 1</SPAN> | AIR</SPAN> |
K10</SPAN> | 2/14/2013</SPAN> | GJ</SPAN> | AN</SPAN> | 5</SPAN> | OCEAN</SPAN> |
K11</SPAN> | 2/15/2013</SPAN> | MS</SPAN> | ND</SPAN> | 3</SPAN> | LAND</SPAN> |
K12</SPAN> | 2/16/2013</SPAN> | KF</SPAN> | IR</SPAN> | 2</SPAN> | AIR</SPAN> |
K13</SPAN> | 2/17/2013</SPAN> | JI</SPAN> | AN</SPAN> | 8</SPAN> | OCEAN</SPAN> |
K14</SPAN> | 2/18/2013</SPAN> | PP</SPAN> | ND</SPAN> | 6</SPAN> | LAND</SPAN> |
K15</SPAN> | 2/19/2013</SPAN> | TE</SPAN> | IR</SPAN> | 3</SPAN> | AIR</SPAN> |
K16</SPAN> | 2/20/2013</SPAN> | FH</SPAN> | AN</SPAN> | 0</SPAN> | OCEAN</SPAN> |
K17</SPAN> | 2/21/2013</SPAN> | JV</SPAN> | ND</SPAN> | 6</SPAN> | LAND</SPAN> |
K18</SPAN> | 2/22/2013</SPAN> | MM</SPAN> | IR</SPAN> | 8</SPAN> | AIR</SPAN> |
K19</SPAN> | 2/23/2013</SPAN> | NS</SPAN> | AN</SPAN> | 7</SPAN> | OCEAN</SPAN> |
K20</SPAN> | 2/24/2013</SPAN> | PI</SPAN> | ND</SPAN> | 1</SPAN> | LAND</SPAN> |
<TBODY>
</TBODY>
I will like to split this master into different tabs using column F to look like this:
K1</SPAN> | 2/5/2013</SPAN> | SA</SPAN> | AN</SPAN> | 3</SPAN> | OCEAN</SPAN> |
K4</SPAN> | 2/8/2013</SPAN> | OO</SPAN> | AN</SPAN> | 6</SPAN> | OCEAN</SPAN> |
K7</SPAN> | 2/11/2013</SPAN> | QW</SPAN> | AN</SPAN> | 3</SPAN> | OCEAN</SPAN> |
<TBODY>
</TBODY>
K2</SPAN> | 2/6/2013</SPAN> | GH</SPAN> | ND</SPAN> | 2</SPAN> | LAND</SPAN> |
K5</SPAN> | 2/9/2013</SPAN> | EE</SPAN> | ND</SPAN> | 3</SPAN> | LAND</SPAN> |
K8</SPAN> | 2/12/2013</SPAN> | QS</SPAN> | ND</SPAN> | 0</SPAN> | LAND</SPAN> |
<TBODY>
</TBODY>
thanks