Help : Material Identification Labels in VBA Excel

[Sachin Bhor]

Hello Friends,
Please help me to create Material Identification labels, reference file attached.
I want to generate Identification lables in VBA Excel

Details as below :-
File having Two sheets 1) Raw Material Record 2 ) Material Sticker

Based on data available in "Raw material Record" need to generate Material Label in "Material Sticker " as per format given in Sheet

please refer the sheet so that you can get idea

Only package quantity to be added as per actual packages & quantity received in Shipment

For Example for entry No. 1

We have received
Material - PP BLACK
Total Quantity - 10000 KG

Now the situation is we have received 10 boxes having 100 kg weight.
So we need to create 10 labels & sticker Batch Quantity will be - 10000 Kg & Package Quantity will be - 100 Kg on each sticker

Can we do this with help of Userform.

Thanks in advance,
Sachin Bhor

 

[Sachin Bhor]

Hi Friends,
please can anyone help me on this

 

[vletm]

Sachin Bhor
Where do You need Userform?
Where do You need VBA?
Have You tried to do it by controlling printing manually?
... You print 'one' label as many times as needed.

 

[Sachin Bhor]

Sachin Bhor
Where do You need Userform?
Where do You need VBA?
Have You tried to do it by controlling printing manually?
... You print 'one' label as many times as needed.

Hello Sir,
Thanks for your response.

1) Where do You need Userform? - needed Userform in sheet "Raw Material Record"
2 )Where do You need VBA? - VBA to be catch data from "Raw material record" & transfer it in to Sticker Formats in sheet "RM material Sticker"
3)Have You tried to do it by controlling printing manually? - Yes but It would be better if we make it automated through VBA
4)... You print 'one' label as many times as needed. - Yes, you are right but i want to create multiple stickers as per no . of packages received in shipment

also note that as mentioned in my original post, in every sticker Batch Qauntity will be same total received quantity & package quantity will change on every sticker as per physically package quantity in shipment

so my requirement is i need option in userform that "No of Stickers required" and after giving commang it should ask me for each package qauntity and after posting/save it should create no of stickers as per entered qaunity in user form

attached another one file for reference

please use command buttom named "INWARD ENTRY " to take trial in below snap



Thanks in Advance,
Sachin Bhor

 

[vletm]

Sachin Bhor
First of all - I do not use Userforms.
Seems that Your 'need' has some changing/moving features - many things should be clear before anything = good plan.
Have You tried to do those manually?

 

[Sachin Bhor]

Hello Sir,
Yes, I tried to do manually
It is posible but it takes much time to create every sticker with different package quantity

 

[vletm]

Sachin Bhor
Do You have an idea, how many stickers would You print out to one sheet?
How long time is Your 'it takes much time'?

 

[Sachin Bhor]

Sachin Bhor
Do You have an idea, how many stickers would You print out to one sheet?
How long time is Your 'it takes much time'?

Hello Sir,
There will be 16 stikers per sheet print out and for one entry there will be 4-5 sheets print out
It will take minimum 10-15 minuts per entry and daily there will be 20-25 entries done
This entries will be done by store operator

 

[vletm]

Sachin Bhor
A sample, based You original writings (#1) ...
1) select any cell (which You would like to use) from 'Raw Material Record'-sheet
2) have printer ready
3) press [ Stickers ]-button
4) follow instructions

Note: I won't and I have not tested all [im]possible variations which user could do!​

 

[Sachin Bhor]

Sachin Bhor
A sample, based You original writings (#1) ...
1) select any cell (which You would like to use) from 'Raw Material Record'-sheet
2) have printer ready
3) press [ Stickers ]-button
4) follow instructions

Note: I won't and I have not tested all [im]possible variations which user could do!​

Thanks a lot, its working Awesome !!