View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Smithz
 
Posts: n/a
Default 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