+ Reply to Thread
Results 1 to 3 of 3

Is there a function for adding text from 'latest update' cells to 'historic actions' cell?

  1. #1
    Registered User
    Join Date
    01-15-2021
    Location
    Southport, England
    MS-Off Ver
    Version 16.30 - License 2019
    Posts
    2

    Is there a function for adding text from 'latest update' cells to 'historic actions' cell?

    Hi,

    Hopefully someone on here will be able to help with my issue.

    I am creating an excel table that will be used by a salesperson at our company. It currently has a list of about 100 companies along with their contact details. However, because his sales process can often involve multiple points of contact (an initial call to a gatekeeper, another call a week later to chase a decision-maker, an email sent with details on our company, etc) until we hopefully take the lead on as a client I would like to add a 'historic actions' column that is automatically updated with his entries into a 'latest actions' column.

    For example it might look like the attached.

    Where anything that's entered in the 'latest action' cells gets added to the start of the 'historic actions' cells when the table is updated. For example a 'historic actions' cell might end up looking like:

    (3rd ACTION) Called Alexandra and arranged a store visit in June | (2nd ACTION) Spoke to receptionist Stephen again and got number of Manager Alexandra | (INITIAL ACTION) Phoned and spoke to receptionist Stephen


    So sorry if this doesn't make any sense, but hopefully someone will be able to decipher my ramblings.

    Thanks,

    Denholme
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Is there a function for adding text from 'latest update' cells to 'historic actions' c

    Your sample file only includes a few examples (3), and they are all for different companies, so it doesn't really form a suitable basis for addressing your main query, which is about combining multiple records for the same company.

    Please attach another sample file which addresses these drawbacks, and please show (manually) what you want to achieve with that data.

    Pete

  3. #3
    Registered User
    Join Date
    01-15-2021
    Location
    Southport, England
    MS-Off Ver
    Version 16.30 - License 2019
    Posts
    2

    Re: Is there a function for adding text from 'latest update' cells to 'historic actions' c

    Hi Pete,

    thanks for getting back to me. I've edited and attached the file again to show how I would like the spreadsheet to act.

    As you can see I would like the 'historic actions' column/cells to update with the text from the 'latest action' column/cells each time the spreadsheet is updated.

    Hopefully this is more clear.

    Any more information you need just let me know.

    Thanks,

    Denholme
    Attached Files Attached Files

+ 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. [SOLVED] Cell to update with latest table column cell value
    By Dbroek in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-18-2020, 10:52 PM
  2. Function adding cells ignoring text cells
    By drgkt in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-14-2019, 05:37 AM
  3. Adding cells from historic data base, as long as they meet two criteria
    By porepiga in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-10-2017, 11:23 AM
  4. [SOLVED] Multi function of actions from value in one cell
    By COURTTROOPER in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-09-2017, 12:23 AM
  5. Help with formula to determine latest timestamp for a variety actions per user
    By katecbernier in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-23-2014, 01:32 PM
  6. Powerpivot - Returning latest update based on latest date
    By Kehjz in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 08-22-2013, 02:45 PM
  7. Replies: 5
    Last Post: 03-30-2010, 08:33 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