none
Artwork garment counting RRS feed

  • Question

  • I have this file and I need to couple tasks, the actual rows are “A2:A29” I am only showing 14 rows I can adjust the code after.

    This is wat I need to happen

    1. Need to know how many rows (cells) of (N or n) until the next option in the example (N or n) starts at row (cell) A2 always to row (cell) A10 then a new option is introduced (starts).
    2. Once I know that then I need to get the total garments for those rows (cells) and displayed in cell “B18” and so on

    If you know this that I have N or, n R or r, & W or w the user my enter it in uppercase or lowercase in the artwork indicator

    Any help will be apricated.


    Vforum

    Thursday, October 31, 2019 7:02 PM

Answers

  • Hi Kosta,

    I've made a sample "Kosta_ArtWork.xlsm" and shared it via OneDrive.
    Please download and see it.

    Regards,
    P.S.
    I hope you will provide a sample that includes actual name of Garments.
    It will help me to understand your requirements.

    Ashidacchi -- http://hokusosha.com

    • Marked as answer by Kosta si Monday, November 4, 2019 1:14 AM
    Friday, November 1, 2019 2:25 AM

All replies

  • Hi Kosta,

    I've made a sample "Kosta_ArtWork.xlsm" and shared it via OneDrive.
    Please download and see it.

    Regards,
    P.S.
    I hope you will provide a sample that includes actual name of Garments.
    It will help me to understand your requirements.

    Ashidacchi -- http://hokusosha.com

    • Marked as answer by Kosta si Monday, November 4, 2019 1:14 AM
    Friday, November 1, 2019 2:25 AM
  • Hi Ashidacchi, sorry for replying late.

    I hope you understand I have no problem sharing a file with you but the file that I am working has to many complicated formulas that I have work on those many year ago and I do not even remember wat are they doing , so I am going through them slowly updating them using VBA coding

    I have attached a link to a stand along file that is doing that part of the coding.

    The task is to find the quantity of garments that matching to a specific criteria in this instant trying to find if a artwork with  no charge "N", artwork chargeable "1" and artwork that is reused "R" is bean used and for how many garments for each, that will determent the cost to print those garments the higher the quantity the cost is last per garment(and there is a formula for that)

    This the best I can come up if you have a better way doing this and shorter please let me know

    What I done looks good but is not perfect

    For example the first set of garments are black color garments and they are no charge for the artwork so is “N” but the next set “N” is white garments again is no charge for the garment so is “N”, but the quantities of the white garment cannot be mixed with black garments.

    I will be working on that tommorow but if you can come with the solution I will apricated also

    Again, thank you,

    Kosta

    PS; I don’t know how to send you a link with oneDrive that is why I use the DropBox sorry

    https://www.dropbox.com/s/wj09eq6jslfefx3/test%20110119.xlsm?dl=0


    Vforum

    Saturday, November 2, 2019 5:30 AM
  • Excel 365 Pro Plus with PowerPivot and Power Query (aka Get & Transform)
    Count quantity and calculate cost.
    With some modern Excel features.
    No formulas, no VBA macro.
    http://www.mediafire.com/file/mx67g9zwzsugr78/11_02_19a.xlsx/file
    http://www.mediafire.com/file/vcuopig390cji9l/11_02_19a.pdf/file

    Sunday, November 3, 2019 3:19 AM
  • I have no idea what you are talking about, but sounds good i will take look the links you have send me and see i a can tackled by my self or maybe i will need some help.

    let you know.

    thank you,

    Kosta

     

    Vforum

    Monday, November 4, 2019 1:17 AM