Dear Sir
I would like to create Excel file that can i use to print label
I have different size of label Like 7cm*3.7cm (No. of label is 24) or 3.5cm*1.85cm (No. of label is 96) and many other on A4 paper
i would like to know how can with macro or function adjust size according to paper (enter document size and Cell width and height and )
second
i have 5 case as in this file (color cell )
i would like when i select any case only show data related to this case and print it on label
Please Note that data want to add the label is
A2, B2, C2 , D2 , E2, F2 and soon
Bookmarks