View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tre_cool[_6_] Tre_cool[_6_] is offline
external usenet poster
 
Posts: 1
Default copying value into alphanumeric table


Hi,
I've spent hours trying to work this out and I can't get it. I nee
some help to copy a value and grid location into a table in anothe
worksheet. For example, in one worksheet I have in one cell, the tabl
location (i.e C3), and in another cell a number (ie. 1234). On a secon
sheet, I have a table and I would like it to copy 1234 into tabl
location, C3. Note, on the first sheet the number and table locatio
values are changing (table location is a manual input). Eventually,
would enter many grid locations in sheet1 and a corresponding valu
appears in the second cell and then I would like a macro that will fil
in the table in sheet2.


Eg.
Sheet1 Sheet2
A B C A B C
1 C3 1
2 1234 2
3 3 (wan
1234 to copy here)
4 4
5 5


Thanks in advance!
Trevo

--
Tre_coo
-----------------------------------------------------------------------
Tre_cool's Profile: http://www.excelforum.com/member.php...fo&userid=2641
View this thread: http://www.excelforum.com/showthread.php?threadid=44109