how to link data from one source sheet to multiple sheets

[Guest]

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.

 

[Guest]

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

 

[Guest]

Hello Shane, Thank you very much.
I do not VB but I will try this and get back to you again.
Once again thanks.