+ Reply to Thread
Results 1 to 10 of 10

view and correction data

  1. #1
    Registered User
    Join Date
    03-26-2013
    Location
    egypt
    MS-Off Ver
    Excel 2007
    Posts
    61

    view and correction data

    i have tow problem
    i have design a shape of invoice, i entered data in blue cells, i want from forum to help my in two code,
    one is : view data from sheet1, i have my invoice NO that i want when i entered it in cell "d2" and clicking on view button show my data that i enter before in sheet1.." the data will appear in blue cells "
    second is : correction when i were correct data and modify on it want correction button to copy amendment to sheet 1..
    .
    Attached Files Attached Files

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

    Re: view and correction data

    Try the attached file.
    Attached Files Attached Files

  3. #3
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: view and correction data

    Hi mak_pj

    Here's another...
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  4. #4
    Registered User
    Join Date
    03-26-2013
    Location
    egypt
    MS-Off Ver
    Excel 2007
    Posts
    61

    Re: view and correction data

    thank you for your interest, codes working excellence but still correction code miss amendment to customer, date and entry#
    thank you for help,
    mak

  5. #5
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: view and correction data

    Hi mak_pj

    To what Code are you referring?

  6. #6
    Registered User
    Join Date
    03-26-2013
    Location
    egypt
    MS-Off Ver
    Excel 2007
    Posts
    61

    Re: view and correction data

    Hi jaslaka
    i referring to two attachment, in correction code, if i modify customer name or date or entry dosen't make change to my data sheet
    on mak_pj attachment if i change customer name or entry or date, code make change to first row only... check it
    on view and correction v1 attachment, code doesn't make change to customer, date and entry if i modify it...
    thank you for your care

  7. #7
    Registered User
    Join Date
    03-26-2013
    Location
    egypt
    MS-Off Ver
    Excel 2007
    Posts
    61

    Re: view and correction data

    Hi jaslaka
    i referring to two attachment, in correction code, if i modify customer name or date or entry dosen't make change to my data sheet
    on mak_pj attachment if i change customer name or entry or date, code make change to first row only... check it
    on view and correction v1 attachment, code doesn't make change to customer, date and entry if i modify it...
    thank you for your care

  8. #8
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: view and correction data

    Hi mak_pj

    For the life of me I can't imagine why you'd want to change the Customer Name or Date or Entry but then, it's not my project. This Code assigned to the Correction Button allows you to change EVERY Field.
    Please Login or Register  to view this content.

  9. #9
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: view and correction data

    Hi mak_pj

    Nevermind

  10. #10
    Registered User
    Join Date
    03-26-2013
    Location
    egypt
    MS-Off Ver
    Excel 2007
    Posts
    61

    Re: view and correction data

    Hi jaslake
    i appreciate that you are tired with me
    much thanks to you..

+ 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: 3
    Last Post: 08-31-2012, 12:40 PM
  2. Replies: 2
    Last Post: 05-24-2012, 05:02 PM
  3. [SOLVED] Issue - replies/view count labels in New Posts view
    By teylyn in forum Suggestions for Improvement
    Replies: 5
    Last Post: 03-16-2012, 05:45 AM
  4. Replies: 0
    Last Post: 02-15-2012, 07:26 PM
  5. [SOLVED] Data correction
    By prasad.vanka@computershare.co.uk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2005, 10:05 AM

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