+ Reply to Thread
Results 1 to 3 of 3

Retaining a manual entry in an index table

  1. #1
    Registered User
    Join Date
    08-19-2014
    Location
    DeKalb, IL
    MS-Off Ver
    2013
    Posts
    31

    Retaining a manual entry in an index table

    I've got an indexing table for my business contacts that returns specific columns from a larger table on another sheet based on a drop-down list filter and running into an issue. Say I've filtered to see my contacts in the manufacturing industry and I know that Client A has an issue I need to follow up on, so in my "notes column" I enter "follow up on x". But then when I change the filter, the note doesn't stay connected to that specific client - it just stays in the same row.

    I get why it happens, because it's not referenced and rather is a manual entry - but is there a way to make it so that the entry stays associated with that particular entry? I'm not even sure where I could start with this one.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,007

    Re: Retaining a manual entry in an index table

    But then when I change the filter, the note doesn't stay connected to that specific client - it just stays in the same row.
    If you mean that it stays in teh same row as the client, then it is still "associated" with that client?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-19-2014
    Location
    DeKalb, IL
    MS-Off Ver
    2013
    Posts
    31
    Quote Originally Posted by FDibbins View Post
    If you mean that it stays in teh same row as the client, then it is still "associated" with that client?
    Edit: I realize I never even bothered to upload the example that I created.

    I just want to type something in the "Comments" column, and it stay with the right person when I change filters. All it does now is stay in the box it's entered into since it's a manual entry in a dynamic table.
    Attached Files Attached Files
    Last edited by sh4d0w1ink; 09-22-2016 at 09:46 AM.

+ 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] Auto Entry to Manual Entry
    By skhari in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-12-2015, 01:19 PM
  2. Auto to Manual Entry
    By skhari in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2015, 03:58 PM
  3. Manual Entry without deleting formula
    By gzoeller in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-01-2015, 08:44 AM
  4. Manual data entry in dynamical table
    By gutkinma in forum Excel General
    Replies: 2
    Last Post: 12-08-2014, 09:00 AM
  5. Replies: 3
    Last Post: 12-31-2011, 10:19 PM
  6. Replies: 0
    Last Post: 10-06-2011, 07:03 AM
  7. Automated entry in one field to change values in another instead of manual entry
    By Josiah in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-23-2008, 08:22 PM

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