Copy rows from master and paste into other worksheets

[ixthoughtxso]

Hi all,

I am a second year analyst at a bank and I have recently been battling with VBA. I have tried recording a macro to do the below, but I feel I am no where close.

I have a huge data dump in one sheet called Report with client names in column A. the headings of the first row are always standard.
1) I have created a template sheet that creates a scatterplot when Row 2 is pasted with data
2) I also have a macro that can create as many copies of the template sheet as I input and calls the tabs Chart1, Chart2, Chart3, etc.

The issue is, I need a macro that could copy 1 row from Report and paste it onto Chart1, and copy the following row from Report and paste it onto Chart2. The sheets are there already, so there'd be no need for the macro to create any.

Can anyone help me out? Thanks in advance

 

[MI man]

Dont know how far am giving you the right information, but you can write a loop (mostly FOR...NEXT loop) to resolve the issue..
like:

Dim i as integer
For i = 1 to 20000
YOUR STATEMENTS
NEXT

(here i = 1 to 20000 refers to rows: row number 1 to row number 20000 of the rows in datasheet.)

Ignore this if am wrong..!!

___________________________________________

Am not an expert at anything...Am a rookie at everything...!!

 

[Brianwarnock]

To add to MI man's comment the code below copies the rows from sheet1 to the following sheets in the workbook in row 1 .

Dim r As Integer
Sheets("Sheet1").Activate
For r = 1 To Cells(65536, 1).End(xlUp).Row
Rows(r).Copy Destination:=Sheets(r + 1).Cells(1, 1)
Next r

 

[ixthoughtxso]

Thank you both very much. The code worked like a charm.