Help me!! Copying text from File to another automatically

R

rhollemans

I need to figure out how to copy text information from a cell on on
sheet to a nother cell on another sheet and/or file. I don't want t
use cut and paste. I can easily get values to copy but I can't seem t
figure out text
 
D

Don Guillett

If you copy the cell it should copy text or numbers
=sheet1!a1
range("a34")=sheets("sheet1").range("a1")
 
Top