Consulting

Results 1 to 2 of 2

Thread: VBA loop and printing help

  1. #1
    VBAX Newbie
    Joined
    Dec 2013
    Posts
    1
    Location

    VBA loop and printing help

    Hello,

    Attached I have a form that has been causing me problems. I want to fill in information from another sheet onto this form but I cannot figure out how to do it. The information I need to apply to this sheet is the SKU, the batch run, and the date. I know how to apply the date but I am stuck on the run and sku. The sheet holds 7 columns for the sku meaning that 1 sheet is needed for a batch run of 7. If there is a batch run of 8 then 2 sheets are needed and so on.

    So far in my code I have a Excel Sheet that has places to write down the information and a large button. The VBA code runs off that button, opens the attached workbook, adds the information, then prints and closes the attached workbook.

    What I need is the sheets printed and columns filled to be dependant on the batch run number. Meaning that if a sku is being made 7 times then it would only require one sheet to be filled out and printed. If there was 8 runs for an sku then 2 sheets need to be pritned out one with 7 columns of info and another with only one column of info. If there is 2 runs then one sheet is printed and 2 columns are filled out.

    Is there anything that can get me started as how to do this?
    Attached Files Attached Files

  2. #2
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,844

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •