View Single Post
  #1   Report Post  
tjhorne
 
Posts: n/a
Default Help with getting text from "Merged Cell"


I have a merged cell that spans from B:7 to B:18 (on worksheet named,
OperatingRevenue) and I am trying to get that text to display in
another worksheet (worksheet named, Upload) within the same xls file.

I am using the following function but it doesn't seem to work:

=+OperatingRevenue!B7:B18

Any ideas?

Thanks!

Todd H.


--
tjhorne
------------------------------------------------------------------------
tjhorne's Profile: http://www.excelforum.com/member.php...o&userid=27871
View this thread: http://www.excelforum.com/showthread...hreadid=473753