+ Reply to Thread
Results 1 to 13 of 13

Macro button to transfer Inventory to sales orders.

  1. #1
    Registered User
    Join Date
    08-24-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2007
    Posts
    78

    Macro button to transfer Inventory to sales orders.

    Can someone please help design a Macro to draw from my armele inventory sheet to be placed into my Mat. Req. form. I need Decription, Cost, Units to transfer over to the form with the use of a button or click to then continuee to the next entry. Thank you!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-24-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2007
    Posts
    78

    Re: Macro button to transfer Inventory to sales orders.

    Can anybody please help with this?

  3. #3
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Macro button to transfer Inventory to sales orders.

    Your original post is not even half a day old. Please give it time for someone to VOLUNTEER their own time to helping you.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

  4. #4
    Registered User
    Join Date
    08-24-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2007
    Posts
    78

    Re: Macro button to transfer Inventory to sales orders.

    Quote Originally Posted by Mordred View Post
    Your original post is not even half a day old. Please give it time for someone to VOLUNTEER their own time to helping you.

    Sorry! Thanks Mordred

  5. #5
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,156

    Re: Macro button to transfer Inventory to sales orders.

    I'm a bit confused, are you just wanting the data you mentioned just copying across into your form sheet? Or are you wanting to select the entries manually and just add selected ones to your form sheet?

  6. #6
    Registered User
    Join Date
    08-24-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2007
    Posts
    78

    Re: Macro button to transfer Inventory to sales orders.

    Quote Originally Posted by Kyle123 View Post
    I'm a bit confused, are you just wanting the data you mentioned just copying across into your form sheet? Or are you wanting to select the entries manually and just add selected ones to your form sheet?

    Yes, thankyou Kyle123 for asking.

    What I would like to see happen is on my inventory sheet (armele) which could be very long, is to have in column (G) on sheet (armele) to left click an (X) or (Add) button for each item in my inventory. I need to have just the (Description, U, Cost,) to transer into my (Mat. Req.) form. Possibly a transfer button of some kind to transfer all the items at once after clicking on the ones in (armele) sheet in column (G). Also, if possible a clear button to clear the (Mat. Req. Form) and (armele sheet selected items only (G)) and to change the Purchase Order # number to the next number in the upper right hand corner of the (Mat. Req. Form). A Print button would be great to have also on the (Mat. Req. Form) Sorry for my long winded run on sentences. Please help me if you can!

  7. #7
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,194

    Re: Macro button to transfer Inventory to sales orders.

    Let me know:
    Attached Files Attached Files
    Ben Van Johnson

  8. #8
    Registered User
    Join Date
    08-24-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2007
    Posts
    78

    Thumbs up Re: Macro button to transfer Inventory to sales orders.

    Quote Originally Posted by protonLeah View Post
    Let me know:
    protonLeah,

    Your awesome that's exactly what I was looking for. Is it possible to add a print button on the (mat. req.) form also and a Purchase Order Number in the upper right hand corner of the mat. req. form that will go to the next number after it’s printed? Also, is there a way to fix the (mat. req.) form so that when I type in an item manually on the mat. req. form and then go back and add other items from the (armele sheet) automatically that it would transfer those items after the last entry on the (mat. req.) form? Thanks again if you can make it work and if you have the time.

    Most respectfully grateful,

    ElmerFud
    Last edited by ElmerFud; 08-29-2011 at 04:56 PM.

  9. #9
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,194

    Re: Macro button to transfer Inventory to sales orders.

    1. add a print button on the (mat. req.) - o.k.
    2. Purchase Order Number (note: increments on clear not print) - o.k.
    3. fix the (mat. req.) form so that when I type in an item manually on the mat. req. form and then go back and add other items from the (armele sheet) automatically that it would transfer those items after the last entry on the (mat. req.) form - o.k.

    ** Your form is very wide and I had to print landscape with very narrow margins vs. portrait; you may have to adjust the columns, depending on your printer.
    Last edited by protonLeah; 09-04-2011 at 11:56 PM.

  10. #10
    Registered User
    Join Date
    08-24-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2007
    Posts
    78

    Re: Macro button to transfer Inventory to sales orders.

    Beyond awesome!!! Thank you so much for your time and effort that you put into making it work. I have the upmost respect for people like you that can do things like this.

  11. #11
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,194

    Re: Macro button to transfer Inventory to sales orders.

    Again thanks so much, works like a charm. Another request if possible, if you don't have time don't worry about it, it works fantastic as is. Is it possible when you hit the print button that it could print two pages and the second page only have the words Duplicate Only! going across the page in large washed out gray letters?
    Excel does not have a watermark feature. To simulate one:
    1. I created a bmp picture with a transparent background,
    2. I added a new sheet and inserted the pic there,
    3. I used Excel's camera utility to "snapshot" the order form sheet and paste to the new sheet on top of the "duplicate" picture.
    4. The new sheet is protected (no password) since there is nothing on it that should be modified (it only/always reflects data on the form)
    5. I modified the print macro to include both sheets.
    Attached Files Attached Files

  12. #12
    Registered User
    Join Date
    08-24-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2007
    Posts
    78

    Re: Macro button to transfer Inventory to sales orders.

    Simply amazing, Thanks so much protonLeah, YOU ARE THE FORUM GURU!!!

  13. #13
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,194

    Re: Macro button to transfer Inventory to sales orders.

    Modified print macro:

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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