+ Reply to Thread
Results 1 to 2 of 2

Copying from textbox to relative cell in array

Hybrid View

kuraitori Copying from textbox to... 11-07-2008, 02:37 PM
rylo Hi can you please attach... 11-07-2008, 08:27 PM
  1. #1
    Forum Contributor
    Join Date
    10-17-2008
    Location
    Vancouver
    MS-Off Ver
    2002 and XP
    Posts
    117

    Copying from textbox to relative cell in array

    Okay, I have made a dynamic hyperlink based on

    HYPERLINK("#"&ADDRESS(S16,S15+2),"Click here to go to 'last case' cell"))
    with S15 =
    =(SUMPRODUCT((O14:O70=O5)*(COLUMN(O14:O70))))
    and s16 =
    =SUMPRODUCT((O14:O70=O5)*(ROW(O14:O70)))
    Now, the thing is I am trying to make a textbox copy its value to the dynamically referenced cell (according to the lookup cell of O5)

    This is basically person selectes a month (in the lookup cell) which reutrns that month "cell address" in a reference table. the text box would enable the person to enter in information that would go adjactive to the referenced cell 9in the table)

    Any ideas?

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    Hi

    can you please attach an example file, and include relevant code. I'm not really sure from your description of what is where....


    rylo

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1