USD $20.00 to amend the installed macro to do a new feature

    $2.00 sent to ozgrid paypal - Transaction ID: 499496217K197552N

    I need someone with alot more skill than me to look at this. The attached worksheet was put together with alot of help form the forums. It is working fine when i put in all the information, I start at C4 on the billing sheet tab, with the Picked up date, and tab thru the rest of the options. But I now need the Accessorial charges to list out if selected? Currently after the first one is selected, a msg box comes up asking if you would like to select another accessorial charge, if yes it just adds to the total and does not show record of it on the Billing Sheet. I need the Accessorial charges selected to list out in row 21, under the Accessorial cell in A20 if possible. The total box is fine, the dollar amount does not need to list out with the selected Accessorial charges. Is this doable?

    Re: USD $20.00 to amend the installed macro to do a new feature


    Hi


    What about if you create another namerange 'AccessList' by concatenating Col K & Col L and apply that name in Billing sheet ?


    If this makes sense, it's done, otherwise I can look at this for you.

    Re: USD $20.00 to amend the installed macro to do a new feature


    Quote from Krishnakumar;788134

    Hi


    What about if you create another namerange 'AccessList' by concatenating Col K & Col L and apply that name in Billing sheet ?


    If this makes sense, it's done, otherwise I can look at this for you.


    please have a look at it. I would appreciate it! Thank you

    Re: USD $20.00 to amend the installed macro to do a new feature


    Okay. So If I show the charges in Col A beneath the Accessorial selection, I need another 4 rows to be added to accommodate the charges. To avoid this, what about If I show the charges in Col B,E or F ? The charge will show against the selection, not beneath the row. (I guess the Accessorial charge is the rate from Col L on ACCESSORIAL sheet)

    Re: USD $20.00 to amend the installed macro to do a new feature


    Hi Krishna Kumar, showing the charges in col b, etc. sounds fine, not adding additional rows. Thank you

    Re: USD $20.00 to amend the installed macro to do a new feature


    I can't attach the workbook as I'm at work now. If you could adjust the code, I can provide the code now. Otherwise I'll post the code later in the evening 9 hours from now.

    Re: USD $20.00 to amend the installed macro to do a new feature


    Go ahead and post later. I'm at home now without a working pc. I will send the balance in the am, Seattle time. Send me your PayPal in a private message. I'll be at work in about 10 hours. Have a good day and thank you for the quick work.

    Re: USD $20.00 to amend the installed macro to do a new feature


    Quote from Krishnakumar;788224

    Payment received, thanks !


    Please find attached the file.


    Great thank you, I will test it out in a bit, and let you know how it is going. Thanks for the quick work.

Participate now!

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

Register Yourself Login