+ Reply to Thread
Results 1 to 17 of 17

Data Entry need to Printing

  1. #1
    Registered User
    Join Date
    05-20-2014
    MS-Off Ver
    2016
    Posts
    82

    Lightbulb Data Entry need to Printing

    Data Entry for FG & PG.xlsmI'm using you Offset to the Data Entry , But i need to be Saved in a temporary SPAC for printing and when the press botton of printing is clear for the next data.
    Thank you
    Attached Files Attached Files
    Last edited by Reidelemanuel; 07-15-2015 at 08:34 AM.

  2. #2
    Registered User
    Join Date
    05-20-2014
    MS-Off Ver
    2016
    Posts
    82

    Re: Data Entry need to Printing

    Enyone can Help.please

  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: Data Entry need to Printing

    Hi Reidelemanuel

    Your Code is Password Protected.
    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
    05-20-2014
    MS-Off Ver
    2016
    Posts
    82
    Quote Originally Posted by jaslake View Post
    Hi Reidelemanuel

    Your Code is Password Protected.
    Password 7230

  5. #5
    Registered User
    Join Date
    05-20-2014
    MS-Off Ver
    2016
    Posts
    82
    Quote Originally Posted by Reidelemanuel View Post
    Password 7230
    Thank you for help

  6. #6
    Registered User
    Join Date
    05-20-2014
    MS-Off Ver
    2016
    Posts
    82

    Re: Data Entry need to Printing

    Hello
    Any Help Please

  7. #7
    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: Data Entry need to Printing

    Hi Reidelemanuel

    At what point will the User Click the Printer Button...after each Work Order is created or when the User is finished creating multiple Work Orders?

  8. #8
    Registered User
    Join Date
    05-20-2014
    MS-Off Ver
    2016
    Posts
    82

    Re: Data Entry need to Printing

    I need to printing the last 10 w- order i putting in the database

    Save 10 and them printing

  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: Data Entry need to Printing

    Hi Reidelemanuel

    Is there a reason for 10 being the Magic Number?

  10. #10
    Registered User
    Join Date
    05-20-2014
    MS-Off Ver
    2016
    Posts
    82

    Re: Data Entry need to Printing

    It can be 5,6,7,10,15 but as bag i need print, if data come below

  11. #11
    Registered User
    Join Date
    05-20-2014
    MS-Off Ver
    2016
    Posts
    82

    Re: Data Entry need to Printing

    below.JPG example

  12. #12
    Registered User
    Join Date
    05-20-2014
    MS-Off Ver
    2016
    Posts
    82

    Re: Data Entry need to Printing

    I use offset end x1(up)
    At best end x1(down)
    I do not.!
    Last edited by Reidelemanuel; 07-16-2015 at 12:44 PM.

  13. #13
    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: Data Entry need to Printing

    Hi Reidelemanuel

    Try the Code in the attached. The Code will print out all Work Orders that have been created in the Data Entry session, regardless of the number created.

    Please note, I've added a Dynamic Named Range called PackingPrintRange which Refers To:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    This Code has been added or modified:

    Clear the contents of Named Range PackingPrintRange
    Please Login or Register  to view this content.
    Modify to populate the Named Range PackingPrintRange
    Please Login or Register  to view this content.
    Print out the Named Range PackingPrintRange
    Please Login or Register  to view this content.
    Attached Files Attached Files

  14. #14
    Registered User
    Join Date
    05-20-2014
    MS-Off Ver
    2016
    Posts
    82

    Re: Data Entry need to Printing

    Is Working Perfect!!!!!! thank you
    you are the best

  15. #15
    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: Data Entry need to Printing

    You're welcome...glad I could help. Thanks for the Rep.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  16. #16
    Registered User
    Join Date
    05-20-2014
    MS-Off Ver
    2016
    Posts
    82

    Re: Data Entry need to Printing

    Can i use Share e workbook and different persons add information, if the printing code saved info to the end. when i click the botton can printing all person add information.
    Thank you

  17. #17
    Registered User
    Join Date
    12-23-2015
    Location
    jeddah,saudi arabia
    MS-Off Ver
    microsoft excel 2013
    Posts
    1

    Re: Data Entry need to Printing

    i want to know how to add printing and how to make excel sheet for the cheque copies bookkeeping
    thanks

+ 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: 06-11-2014, 09:23 AM
  2. Replies: 0
    Last Post: 02-04-2014, 12:36 AM
  3. Replies: 4
    Last Post: 02-01-2013, 10:18 AM
  4. how to entry same number twice when I alr set cannnot entry duplicate data.
    By Adamlearnexcel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-05-2012, 09:44 PM
  5. Vba for move data & clear entry screen for entry new data..
    By santosh226001 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-27-2012, 09:19 PM
  6. Replies: 0
    Last Post: 07-18-2012, 03:57 AM
  7. Replies: 0
    Last Post: 10-06-2011, 07:03 AM
  8. How do I prevent data entry in one cell if an entry exist in another cell
    By rkjudy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-13-2010, 09:38 PM

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