Basic Excel for Macro Experts - replicating data across multiple cells
"swatsp0p" wrote in
message If it goes in the same cell on each sheet and there are only a few
cells to replicate, simply select the desired sheets (hold down CTRL
while clicking on desired sheet tabs) then enter a formula in the
desired cell(s) such as:
=Sheet1!A1 etc.
Ahh, I do have a further question regarding this. What if Sheet1 is called -
Example Sheet name with space
-
I am looking it up, but if you happen to know off hand how I reference this
worksheet then great. I have tried quotes and brackets with no luck.
anyone know?
Cheers
|