Hi,

You will need to automate this with VBA: For example, if your data starts
on row 2 and goes to row 29 on Sheet1 and the titles are in cells A1:C1, then
something like this will work. You can enhance the flexibility by having the
code determine how many rows but that depends on you data layout - are there
missing items in some cells, are there totals at the bottom of columns, is
there other data below the data...

Sub CopyData()
For I = 2 To 21
Sheets.Add
Range("C5:E5") = Sheets("sheet1").Range("A" & I & ":C" & I).Value
Next I
End Sub
--
Cheers,
Shane Devenshire


"Ashish Deshmukh" wrote:

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.