Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Go To an address specfied in a cell
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 |
#2
|
|||
|
|||
Go To an address specfied in a cell
Hi Rob,
If you paste something like data!29 into the cell address you get a very explicit error "You must enter a valid reference you want to go to, or type a valid name for the selection." You can paste or type data!29:29 or you can paste or type data!A29 Not sure if you have one or two questions, it seems you know where you want to go. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "WightRob" wrote in message ... 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 |
#3
|
|||
|
|||
Go To an address specfied in a cell
Thanks for your reply David, The reference "Data!29" is a typo, it should read "Data!J29" as in the example below. I have only one question. What I am trying to do is automatically paste a range of values from one worksheet to a specified location on another worksheet (named Data! in my example). The address of the start cell on the worksheet Data! is J29. This address already appears on the first worksheet (it's value changes relative to the week number). If I was doing this manually, I would simply copy the data on the first sheet, go to the cell J29 on the sheet Data! and paste the data in. I want to automate this with a macro. What I don't know how to do is make the cursor move to cell Data!J29 from within the macro. Hope that clarifies it. Regards Rob -- WightRob ------------------------------------------------------------------------ WightRob's Profile: http://www.excelforum.com/member.php...o&userid=13799 View this thread: http://www.excelforum.com/showthread...hreadid=476658 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP!!!! Cell Value in a Cell Address | Excel Worksheet Functions | |||
Replace a spreadsheets named cells/ranges with exact cell address. | Excel Discussion (Misc queries) | |||
ADDRESS function - dynamic input cell | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions |