dragging sheets like dragging cells.

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.

thanks.

I have a table with information about 1 product in each row. Now each product needs to have a separate sheet where this information needs to be included. if i could create one sheet, and then drag it, excel would "know" that it needs to jump a row when creating the next sheet, and then i would have similar 100 sheets with information about 100 different products. 1 in each sheet.