Closed Thread
Results 1 to 2 of 2

Assign data to all column in one worksheet according to a definition in another worksheet

  1. #1
    Registered User
    Join Date
    05-29-2017
    Location
    Prague, Czech Republic
    MS-Off Ver
    10
    Posts
    13

    Assign data to all column in one worksheet according to a definition in another worksheet

    Hello,

    I have one worksheet Definition where I have cca 200 countries and each country is assigned specific region code.
    WORKSHEET Definition - Example:

    Column CTR_CODE | Column Biz_reg
    AM EU
    AD EU
    BH ME
    etc.

    In the same workbook I have worksheet Modified with again CTR_CODE, and here comes the task: I need to assign Biz_reg to all cells according to CTR_CODE/Biz_reg in worksheet Definition
    WORKSHEET Modified - Before

    Column CTR_CODE | Column Biz_reg
    AM
    AD
    BH

    WORKSHEET Modified - Expected Result:
    Column CTR_CODE | Column Biz_reg
    DE US
    AD EU
    BH ME
    AM EU



    Please, could someone help?

    Jana

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Assign data to all column in one worksheet according to a definition in another worksh

    Jana,

    Why must you insist on entering this thread over and over again. Please follow the forum rules and post one time.

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    Thread Closed.
    HTH
    Regards, Jeff

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Assaign data to cells from another worksheet where there is definition
    By jbmd in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 05-29-2017, 04:08 PM
  2. [SOLVED] correct syntax to assign a range from one worksheet to another worksheet?
    By Andrew Entee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2016, 08:22 PM
  3. [SOLVED] Sort data on worksheet, assign priority/key to use in VBA
    By njs27 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-06-2016, 10:46 PM
  4. Moving column data from one worksheet to rows in another worksheet.
    By taichi56 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-12-2013, 09:00 PM
  5. [SOLVED] copy data from cells in a column on one worksheet to a single cell in another worksheet
    By jpsnickers in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-03-2013, 07:02 PM
  6. Replies: 0
    Last Post: 05-20-2013, 10:09 AM
  7. [SOLVED] Need help populating a worksheet based on data from a separate worksheet and column.
    By Rlong1818 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-16-2012, 05:06 PM

Tags for this Thread

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