+ Reply to Thread
Results 1 to 6 of 6

Filling in customer details automatically

  1. #1
    Registered User
    Join Date
    04-29-2011
    Location
    Istanbul, Turkey
    MS-Off Ver
    Excel 2007
    Posts
    10

    Filling in customer details automatically

    Hello, to all. This should be easy but for some reason I cannot do it. But when it comes to computers, I'm like an infant trying to read the newspaper. Here is what I am trying to do:

    There are 2 sheet tabs; R&D (the master tab) & Engagement (where the company’s with NDA will be automatically sent to)

    I will have a list of about 300 or more firms in the R&D tab in which I will contact. After I contact them and they want to receive an NDA, I will write “NDA” in the NDA titled row. Once I write NDA I would like all the info for that company to be automatically transferred into the ENGAGEMENT sheet.

    Thank you again...

    I've attached the template. If someone could help me, I will send positivity to you for the rest of your life!!!
    Attached Files Attached Files
    Last edited by arthurbr; 04-29-2011 at 03:57 AM. Reason: Change title

  2. #2
    Registered User
    Join Date
    04-29-2011
    Location
    Istanbul, Turkey
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Macro formula needed for excel sheet

    I don't know what PM means, but I changed it. Sorry

  3. #3
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Macro formula needed for excel sheet

    PM means Private message.
    Thank you for the effort, but your new title is no more descriptive than the first.
    I would suggest something like "Filling in customer details automatically". I will change it for you

  4. #4
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Filling in customer details automatically

    hi, floridavera, please check attachment, try to change value in filled rows in I column to "nda" and check sheet "Engagement"
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    04-29-2011
    Location
    Istanbul, Turkey
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Filling in customer details automatically

    You are awesome. You rock my world! Thanks sooooo much!

  6. #6
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Filling in customer details automatically

    hi, please check attachment, set some NDA's and sheck result on sheet "Engagement", go back, delete some and check the other sheet again
    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)

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