Results 1 to 3 of 3

Adding record in similar line

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-03-2014
    Location
    India
    MS-Off Ver
    2016 .......
    Posts
    393

    Adding record in similar line

    Hi
    I have uploaded a file which contains macros... don't use Fields sheet
    Sheet 1 : Entry Sheet
    Sheet 2 : Data

    In entry sheet we are entering data on different timing i.e. morning, afternoon & evening
    when I use save button for morning entry it creates 1 record & for afternoon & evening session creates multiple records in DATA sheet for same date & branch.

    I want that when I click on save at afternoon or evening session it has to track if any entry available for date & branch in morning session & update record in the same line of records else create new-one record.

    It is very difficult job to generate multiple records for same date & branch for different timings.... .. I think Excel sheet will not be able to accommodate total data in few days.
    So kindly help & do the needful in urgent.
    Thanks in advance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] problem with adding record replacing first record
    By fredderf81 in forum Access Tables & Databases
    Replies: 1
    Last Post: 07-17-2014, 12:28 PM
  2. Replies: 0
    Last Post: 01-30-2014, 10:12 AM
  3. Replies: 6
    Last Post: 08-09-2013, 12:56 PM
  4. Difficulty adding a trend line to line graph in Excel 2007
    By jmatoske in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-28-2012, 02:59 PM
  5. Replies: 6
    Last Post: 11-26-2012, 05:17 AM
  6. Adding record above the next line based on conditions. VBA required?
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-04-2012, 09:07 AM
  7. Replies: 3
    Last Post: 10-26-2005, 08:05 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