Hello everybody,
I have different tables and workbooks. In Sheet1 of every workbook i have a table that vary in the amount of columns. From this table I have to make a Sheet per column. In each Sheet the cells have to always be column 1 and then the corresponding column. For example:
Table1
<tbody>
</tbody>
here Sheet2 should be Items and Price, Sheet3 should be Items and Area, Sheet4 should be Items and Color and so on.
Is there anyway i can do this without having to be copying and pasting the columns one by one and be able to do it for different workbooks.
Thanks for all your help.
I have different tables and workbooks. In Sheet1 of every workbook i have a table that vary in the amount of columns. From this table I have to make a Sheet per column. In each Sheet the cells have to always be column 1 and then the corresponding column. For example:
Table1
Items | Price | Area | Color | Date |
shirt | 2.00 | up | blue | 12-12-14 |
pants | 3.50 | down | red | 12-11-14 |
<tbody>
</tbody>
here Sheet2 should be Items and Price, Sheet3 should be Items and Area, Sheet4 should be Items and Color and so on.
Is there anyway i can do this without having to be copying and pasting the columns one by one and be able to do it for different workbooks.
Thanks for all your help.