VBA to copy and paste cells (1 Viewer)

kvar

Registered User.
Local time
Today, 14:17
Joined
Nov 2, 2009
Messages
77
This should be simple but I'm not seeing it for some reason.
All I need to do is copy the value of Sheet1.cell and paste it to Sheet2.cell, in some cases I will need to paste the same value into multiple cells on Sheet2 though they are spread throughout.

Any examples of how to do this would be much appreciated!

Fyi....Sheet1 is basically a form to put in certain values, Sheet 2 contains a ton of formulas to create a budget. That is why some values, i.e. percentage of work done in factory, will be put into multiple cells as it is multiplied by the costs of many different parts. It's a bit complex but I don't want people touching that sheet or putting values in the wrong places, so hence the form!
 

Brianwarnock

Retired
Local time
Today, 22:17
Joined
Jun 2, 2003
Messages
12,701
Eg sheets("sheet2").Range("C2")=sheets("sheet1").range("A1")

If you are doing a lot of such coding then

Dim sh1 as worksheet
Set sh1 = sheets("sheet1")

Then you can code sh1.Range("A1")

Brian
 

kvar

Registered User.
Local time
Today, 14:17
Joined
Nov 2, 2009
Messages
77
Thank you! Got everything to work and even figured out how to do unnamed ranges for the few that have cells grouped together, such as:
Sheets("Sheet2").Range("BR16:BS33").Value = Sheets("Sheet2").Range("C9:D26").Value

Thank you so much for getting me started!
 

Brianwarnock

Retired
Local time
Today, 22:17
Joined
Jun 2, 2003
Messages
12,701
Glad to have helped and pleased that you could expand on the info.

Brian
 

Users who are viewing this thread

Top Bottom