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!
Can anybody please help with this?
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---
Originally Posted by Mordred
Sorry! Thanks Mordred
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!
Let me know:
Ben Van Johnson
Re: Macro button to transfer Inventory to sales orders.
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.
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.
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.
Excel does not have a watermark feature. To simulate one: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?
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.
Simply amazing, Thanks so much protonLeah, YOU ARE THE FORUM GURU!!!
Modified print macro:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks