Results 1 to 4 of 4

Please advice: Automatic update of cell text based on the item number (also text)?

Threaded View

Royser12345 Please advice: Automatic... 03-28-2014, 06:32 AM
Fotis1991 Re: Please advice: Automatic... 03-28-2014, 06:53 AM
Royser12345 Re: Please advice: Automatic... 03-28-2014, 07:00 AM
Fotis1991 Re: <SOLVED>Please advice:... 03-28-2014, 07:04 AM
  1. #1
    Registered User
    Join Date
    02-23-2014
    Location
    Norway
    MS-Off Ver
    Excel 2010
    Posts
    49

    Please advice: Automatic update of cell text based on the item number (also text)?

    Greetings,

    I have a column C with different text in cells (item's title). Column D - relevant description for each of the items. 100+ rows.

    Now, unfortunately, often a spreadsheet with items is updated with many new items. So I get a new spreadsheet with old and new items mixed. I need, somehow, to import descriptions of the old items (Column D of the old spreadsheet) to the new spreadsheet from old spreadsheet. So I want excel to look for old items in column A of the new spreadsheet and, once found, insert a description in the column B from old spreadsheet.

    Please see attachment

    Example for forum.xlsx

    Please help!

    Thank you
    Last edited by Royser12345; 03-28-2014 at 07:01 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatic cell number generated by text in a different cell
    By Moonpig1971 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-27-2014, 01:23 PM
  2. [SOLVED] Update Cell text (ie title) based on Worksheet location
    By nomoremacs in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-26-2012, 03:10 AM
  3. VLookUp execution on text box automatic update
    By farzyness in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2011, 10:51 AM
  4. Advice on How to Subsitute/Replace a Text or Number
    By meyero90 in forum Excel General
    Replies: 3
    Last Post: 08-09-2010, 12:53 PM
  5. Automatic navigation based on cell text value
    By bluegrassstateworker in forum Excel General
    Replies: 2
    Last Post: 07-28-2006, 09:50 AM

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