I have a treatment input sheet named SB Production Sheet. The user will enter weight data in cells B9 and B11:B13. The user will also select a treatment type and package type from the dropdowns in B10 and C9, respectively.
The selections that are chosen in these two ranges, relate to the colored tabs. So, for example, if a user selected a treatment type of Proshield and package type of Molly, then the label would need to reflect the warnings label and seed treatment information contained in the purple tab titled Moly PS. There is a listing of the treatments in column G. (The sheet names are in a short hand style of these, hopefully its not difficult to decipher).
If you look at these colored sheets, you can see how we are pulling information from the SB Production Sheet, into these colored label sheets.
What I am needing is to have a label template created, where as the selections are chosen in the SB Production Sheet, then the warning label and product info from the colored sheets are populated into the template sheet. Do not worry about the Proshield logo or the address being carried over from the colored label sheets. Disregard that.
I would recommend using that purple Bag PS sheet as the label template.
Here is how to decipher the sheet name shorthand:
Of course they are all going to begin with Molly or Bag, depending on what is needed. We have different sheets because the labels are different sizes, however, we believe that we can use that purple Bag PS as an "all in one" label maker. Anyway..
PS means Proshield (see column G listing for context for these explanations)
PSI means Proshield & Inoculant
PSX means proshield Xtra... and so on. Use column G as your guide.
So, to recap. Need a label template that pulls the warning label and product information into it from the many different colored sheets, based on what is selected by the user in the SB Production Sheet. in this way, the user can enter in the manual fields in the SB Production sheet that must be manually entered, but then all the other information is dynamically brought over to the label template sheet from the SB Prod. Sheet.
Also, based on what the user selects in the SB prod. sheet, the label and warning information dynamically comes over into the template from the colored sheets based on selection.
I hope this makes sense.
Thank you all very much for all of your help you always give.
17 pekerja bebas membida secara purata $170 untuk pekerjaan ini
Hi, I am good at Excel and vba. Looking forward to work on the project. I have referred the detailed description. Please share the Excel file to read inline with the detailed description. -Chandra
Hi, I am experienced on Microsoft Access , Excel and VBA. I can start your job immediately also. Please contact me to discuss the project in details. Thanks
I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. I'm interested in your proposal. Your task is clear to me and I am ready to solve it.
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.