+ Reply to Thread
Results 1 to 3 of 3

Insert/Delete record in Sheet2 based on cell value in Sheet1

  1. #1
    Registered User
    Join Date
    01-06-2014
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    2

    Insert/Delete record in Sheet2 based on cell value in Sheet1

    Hi All,
    Requesting help to achieve the below requirement.

    Version Microsoft Excel 2010

    Worksheet 1 has two columns A & B:
    Lets assume that column 'A' has names of employees and column 'B' has number of times they are absent to work in a given month.

    The requirement I have is to have a record (employee name) inserted into "Worksheet 2" if column B (in worksheet 1) is ">0" for that employee; and to delete the same record from Worksheet 2 if
    column B is reset to 0.

    i.e.,
    • Insert a new record with Employee Name (from Column A in Worksheet 1) into Worksheet 2 - if and only if "Column B" > 0 (in worksheet 1)
    • Delete the record from Worksheet 2 if column B value for the corresponding employee is reset to 0 in Worksheet 1

    Let me know if you need more information on this.

    Regards...

  2. #2
    Valued Forum Contributor
    Join Date
    09-04-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    463

    Re: Insert/Delete record in Sheet2 based on cell value in Sheet1

    will you upload a sample sheet with expected output or giving one example please?


    Regards
    Mahaveer Somani

  3. #3
    Registered User
    Join Date
    01-06-2014
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Insert/Delete record in Sheet2 based on cell value in Sheet1

    Hi,
    Thanks for your response. Please find attached a sample workbook.

    Explanation:
    Requirement 1: In Sheet1, since only JIM has column B > 0, a corresponding record is inserted in Sheet2 and not for others.
    Requirement 2: If Jim's absence is reset to 0, then the record inserted by requirement 1 should be deleted.

    Thanks for your time!

    Regards.
    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] Click on a cell in sheet1 and find matching record on sheet2
    By vbacheck in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-18-2013, 12:14 AM
  2. how to show record from sheet2 to sheet1 based on selection of combo box
    By mike018 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-15-2013, 02:30 AM
  3. [SOLVED] Take Data From Column on Sheet1 and Insert Into Next Blank Row on Sheet2 Then Clear Sheet1
    By abutler911 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2013, 06:30 PM
  4. Record Data from sheet1 to sheet2 using name as the criteria
    By city in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-29-2012, 06:02 AM
  5. Macro to copy range of cell from sheet1 to sheet2 based on a cell value in sheet2
    By drgwhizz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-25-2012, 10:39 AM

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