Copy Rows down with value from another Cell

[lesley burlingham]

Copy row information down certain number of rows.

I would like to copy row 3 on sheet 1 down the number of rows on C2 on Sheet2.

 

[NARAYANK991]

Hi Lesley ,

Can you specify the number of columns that should be copied ? What is the start cell , is it A3 ?

Suppose C2 on Sheet2 contains the number 10 ; what is supposed to be done ?

Narayan

 

[lesley burlingham]

Hi

I would like to copy Row 3 on sheet 1 the number on C2 sheet 2.

So if someone puts 5 in to C2 sheet2 i want row 3 copied down 5 row.

 

[Nebu]

Hi:

Please find the attached, hope this is what you are looking for the macro button is in sheet 2.

Thanks

 

[lesley burlingham]

Thank you very much. I was able to use the macro to make the sheet work

 

[Smallman]

Hi Lesley

This is a non looping alternative.

Sub CopyIt()
    Sheet1.[a3].Copy
    Sheet2.Range("C3").Resize(Sheet2.[c2], 1).PasteSpecial xlPasteValues
End Sub

Take care

Smallman

 

[John Jairo V]

Hi to all!

Another one:

Sub copyrow()
    Sheet2.[C3].Resize(Sheet2.[C2]) = Sheet1.[A3]
End Sub

Blessings!