I have data in 1st Sheet with column labels: Account No, Name & Amount. It
consisits of data of 20 rows for 20 different accounts.
I want to generate 20 worksheets in the same file each of which will pick
the data from sheet 1. Each new generated sheet will pick the data from sheet
1 to a specified cell. (means i would like to have account no of row 1 at C-5
of new sheet, account no of row 2 at C-5 of other new sheet. Can anybody
please suggest can it be automated?
Thanks in advance.