Change row color without conditional formatting

  • Many Many Thanks for your very kind words ...:):):)


    Extremely pleased to hear that you like it ... and above all that ... this will help you out for your job ...:thumbup:


    Please do test it out ... and jot down all the modifications you might still need ... and do not hesitate to post back ...


    Take Care

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • very grateful!!!!!


    ok i noticed one lil thing


    the function that replicates the row from "Main sheet" to the next available row in "Outstanding Bins" and "Overweight bin" only copies to the next available row downwards, not upwards.


    So if i delete the information in row 3 in outstanding bins sheet and overweight bin sheet, and add another row of information from the main sheet that copies to outstanding bin sheet or overweight bin sheet, that information replicates to row 4, not row 3..


    then again, it may not need to be tweaked because i can sort it?

  • Whenever you are deleting data ... say in the sheet Outstanding Bins ...


    does it create an empty row between the Headers row and the next populated row ...?

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Given the actual structure of your workbook ...


    1. As you said it, an extremely quick fix is indeed to sort the sheet ...

    or

    2. Could add a right-click event mouse which would easily delete the selected row ...


    Your choice ... ;)

  • Hello,


    Since you are using Data Validation to set your Bin Prices ...


    Have a go with following tiny modification : Add Sales Tax 13% for Non-Cash Payments ...


    For your info ... there is NO tracking of your potential various consecutive changes ...:(


    Hope this will help

    :)

  • hey just got in, works great, you gonna hate me lol


    so i decided to rearrange some columns lol, keep customer information to the left and bin information to the right


    I can do the formula tweaking for the drop down menus.


    but not the macro lol


    here is the file of what i want to switch around


    Name of new columns are in brackets inside the header



    Also for Column F (Extra Days)


    1 Day=$15

    2 Days=$30....etc


    So iF i type "1", can that price be automatically added to the bin price in Column C once entered?

  • Before diving into the intricacies of re-coding everything ....:cursing:

    Safer to get a formal confirmation :

    1. F to J
    2. G to I
    3. H to K
    4. I to G
    5. J to H
    6. K to F
    7. L to L

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hello again,


    In addition to your confirmation for all the Columns to be permuted ... you should also clarify your Bin Price calculation process ...


    Indeed, by using a Data validation for prices ...


    1. on one hand, you do NOT have a formula to adjust neither for 13% Sales Tax nor for the $15 charge per Extra Day ...


    2. on the other hand, indeed the macro can automatically perform these adjustments ... BUT ... there is no way back ... (which is automatic with a formula ...) and, as a consequence, any price correction will require re-selecting a ' basic ' price in Column C ...


    Let me have your comments

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • hey sorry, i didnt get a email notification, just looking over this now


    Before diving into the intricacies of re-coding everything ....:cursing:

    Safer to get a formal confirmation :

    1. F to J
    2. G to I
    3. H to K
    4. I to G
    5. J to H
    6. K to F
    7. L to L

    that is correct :thumbup:

    Im okay with selection 2!!!! Thank you!!!! Sooooooooooooooooooooooooooooooooooo MUCH:):):):):):):):):):)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!