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!
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!