Hey,
I have a table with about 100 rows, and i need to create a sheet for each row that will contain information from that row in certain cells in that sheet. Now i want to create one sheet, and then duplicate that sheet (drag it somehow) so that each sheet will contain information from it designated row.
example
cell B4 in sheet 1 will contain cell a1 in the original table
cell B4 in sheet 2 will contain cell a2 in the original table
cell B4 in sheet 3 will contain cell a3 in the original table.
and so on.
tnx.
Bookmarks