+ Reply to Thread
Results 1 to 4 of 4

automate data entry by linking data

  1. #1
    Forum Contributor
    Join Date
    01-08-2008
    Posts
    137

    automate data entry by linking data

    Please view the attached file. What I will describe is easier to understand if you view it. By the way, this is a simplified version of a larger problem I have. Although it may seem a bit trivial, your help here would be enormously beneficial to the big picture.

    1.) On the worksheet called Data one should use this information to complete the worksheet entitled LinkDataHere.
    2.) Needless to say, there are many countries in the world and one may not know where to enter a certain country on the LinkDataHere Worksheet. As a result, I created a map to clear up any confusion.
    3.) What formulas/code could I insert into the worksheet called LinkInHere to automate this?
    Attached Files Attached Files

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Even with yopur workbook open it's not clear what you want.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor
    Join Date
    01-08-2008
    Posts
    137

    revision

    Let me try to explain this again.

    1.) My goal is for someone to be able to paste data on to the Data worksheet and have the LinkDataHere worksheet populated.

    2.) How is the LinkDataHere worksheet populated? Every country/region in column A has to fit into a country/region on the LinkDataHere worksheet. More specifically, the MAP dictates where the GDP value for the country/region on the worksheet Data SHOULD BE ADDED to on the worksheet LinkDataHere.

    3.) Once again, the MAP lets the user know where he should enter the data for the country/region on worksheet Data.

    Let me know if this doesn't help.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    01-08-2008
    Posts
    137

    Solved



    I figured out a way to do this.

    Nevertheless, thank you for your time.

+ 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