Macros to Copy Data

[lesley burlingham]

I would like to add a button on to my spreadshee which copies all the data in sheet 3 and pastes (just values) into sheet one.

 

[Marc L]

Use Macro recorder, the beginner best friend ‼

And here it's the Excel formulas forum …
​

 

[Jagdev Singh]

Hi Lesley

If possible provide some example files for better understanding of your requirement. If you are novice to VBA and not aware of the recording option.

Regards,
JD

 

[lesley burlingham]

Hi
See attcahed. I would like a button on cell I1 sheet 3, which copies all the data on sheet 3 to sheet one. The number of rows changes everytime. I want to paste special so just the values.

 

[lesley burlingham]

Hi
See attcahed. I would like a button on cell I1 sheet 3, which copies all the data on sheet 3 to sheet one. The number of rows changes everytime. I want to paste special so just the values.

 

[Jagdev Singh]

Hi Lesley

Please find the macro attached with the thread.

Regards,
JD

 

[Smallman]

Hi

This should also get you over the line.

Sub CopyIt1()
  Sheets(Array("Sheet1", "Sheet3")).FillAcrossSheets Sheet1.[a1].CurrentRegion
  Sheet3.[a1].CurrentRegion.Value = Sheet3.[a1].CurrentRegion.Value
End Sub

Take care

Smallman