+ Reply to Thread
Results 1 to 6 of 6

Entering data in in 1st blank cell in specific row

  1. #1
    Registered User
    Join Date
    03-04-2014
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    3

    Entering data in in 1st blank cell in specific row

    I have created a form where a date and remark is added every few days. I am using Phone Number as the base of VLookup. I want a code so that the date and remark which is entered in a Text Box, is stored in the first available blank cell pertaining to that employee. I want the first date and remark to be under "Date 1" and "Remark 1".

    Thereafter, if another remark is subsequently added for that employee, the form would ask to enter his phone number to identify which employee the remark pertains to. Then the Text Box where remark is entered should be stored under "Remark 1" if there has been no remark before, "Remark 2" if "Remark 1" already exists, "Remark 3" if "Remark 2" already exists and so on.

    I do not want to enter it in a new row. I want to enter the remark in the next blank cell of the row which matches the employee Phone Number.

    Please Help.

    Untitled.png

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,837

    Re: Entering data in in 1st blank cell in specific row

    It would be easier to help if you could attach a copy of your Excel file including your form rather than a screenshot.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Registered User
    Join Date
    03-04-2014
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: Entering data in in 1st blank cell in specific row

    Here it is.

    Any inputs would be helpful. Thanks.
    Attached Files Attached Files

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,837

    Re: Entering data in in 1st blank cell in specific row

    Perhaps this macro can be a starting point for you. I've included comments to describe what the lines of code do. You will have to adapt it in your form code modules.
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    03-04-2014
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: Entering data in in 1st blank cell in specific row

    Thanks for the help

  6. #6
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,837

    Re: Entering data in in 1st blank cell in specific row

    My pleasure.

+ 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. Replies: 1
    Last Post: 11-18-2013, 04:18 PM
  2. Entering data daily into one specific cell
    By nkhan618 in forum Excel General
    Replies: 1
    Last Post: 10-31-2012, 04:38 PM
  3. [SOLVED] Entering a blank if there is missing data in another cell
    By Beazle in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-29-2012, 12:28 PM
  4. Entering Value in Blank Cell
    By radzian in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-30-2008, 02:03 AM
  5. [SOLVED] finding blank cell and moving specific data into it
    By BeJay in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-30-2006, 02:10 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