+ Reply to Thread
Results 1 to 2 of 2

Can a cell automatically be filled with data, based on data in another cell?

  1. #1
    Registered User
    Join Date
    10-13-2015
    Location
    Nijmegen, The Netherlands
    MS-Off Ver
    2007
    Posts
    3

    Can a cell automatically be filled with data, based on data in another cell?

    Dear reader,

    Here is my problem:

    I have one already filled table on the right (column A, B, C and D) and I want to put some of these data (from column A, D and C) in a new table (left). This is based on data in column E and whenever I want to place data from right column A row X into left column A row Z I also want to fill in the data from right column C row X into left column C row Z and the same for columns D. See below for an example.

    Is there a formula that I can use that automatically fills in the left columns D and C, based on what I fill in in the left column A?

    A E D C A B C D
    3 other data # c 1 A a !
    10 other data ) j 2 B b @
    other data 3 C c #
    other data 4 D d $
    other data 5 E e %
    other data 6 F f ^
    other data 7 G g &
    other data 8 H h *
    other data 9 I i (
    other data 10 J j )


    Thank you in advance!

    Best,
    Susann

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2302
    Posts
    38,617

    Re: Can a cell automatically be filled with data, based on data in another cell?

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Glenn



+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatically increase rows based on cell data
    By BoydCrowder'sCollar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-16-2015, 05:14 AM
  2. Automatically Filter Data Based on what is entered into cell
    By bpyoung83 in forum Excel Programming / VBA / Macros
    Replies: 34
    Last Post: 09-07-2013, 03:54 AM
  3. Formulas should be filled automatically from specific cell when New data is entered
    By indudhar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2013, 09:17 PM
  4. Automatically move a row of data based on cell value
    By mmogharreban in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-16-2013, 02:37 PM
  5. Automatically populate data based on another cell
    By fmluder93 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2011, 09:19 PM
  6. Need To Input Data Automatically In One Cell Based On Data In Cell Next To It
    By beltman713 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-19-2008, 10:19 PM
  7. [SOLVED] Can an Excel macro be automatically run based upon data in a cell?
    By chasedan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-10-2006, 07:25 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