Hello Folks,

Does anyone know how I can move the cursor to a cell, the address of
which is specified in another cell?
Here is the scenario. I enter a list of hours worked in a specfic week
on a data entry sheet. I hit a button and the values are copied to a
data summary sheet, the position depends on the Week No., the first
cell is specfied as the address "Data!29" for Week 5. I reckon I can
handle a recorded macro to copy and paste the data but how do I locate
the correct start cell?
I have tried copying and pasting into the GoTo box but that doesn't
work.


Data!J29


Week No 5



Sat 0.00
Sun 0.00
Mon 9.50
Tue 9.00
Wed 8.50
Thur 8.00
Fri 6.00


Thanks in anticipation.
Rob


--
WightRob
------------------------------------------------------------------------
WightRob's Profile: http://www.excelforum.com/member.php...o&userid=13799
View this thread: http://www.excelforum.com/showthread...hreadid=476658