Posts by steve400243

Hello the attached worksheet works fine on office 2010, but when a user tries to work with it in 2013 it gets an error code of "could not load an object because it is not available on this machine"?? any ideas? Thank you in advance [ATTACH]n1193441[/ATTACH]

Re: trying to create vba to copy data when option button is selected

Quote from Logit;794633

See your other forum posting

Thank you. I will.

Hello, on the attached worksheet I am looking for VBA Then when the transfer to complete option is selected, transfer the data starting in A3 to I3 to the complete tab and auto saving for history. Then clearing all data starting in row 3 on the 1st tab making the worksheet ready for the next user. Also the date and time listed in I1 like the example shown on the complete tab. Thank you in advance for all help.

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

This is working as needed, Thank you Kris.

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.

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

Hello Kris, PayPal sent - Transaction ID: 00T77252K33111400

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

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

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

$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 $30.00 Seeking totals by month, and working hours

Quote from KjBox;787207

OK, thanks. I will switch the values in the affected rows so the dates make more sense and the formulas will work!

Hello KjBox, Please update on this project. Hoping to get it before I go home for the weekend. Thank you -

Re: USD $20.00 Copy and paste row data to separate worksheet when certain cell is upd

Please dont worry about that last request if you saw it, I figured it out - Thanks again.

Re: USD $20.00 Copy and paste row data to separate worksheet when certain cell is upd

Thank you for the quick work, very much appreciated. I will let you know if any issues arise.

Re: USD $20.00 Copy and paste row data to separate worksheet when certain cell is upd

Quote from S M C;787677

Can have a look now

Thank you!

10% paid to ozgrid Transaction ID: 73H98692PG5629545

On the “2017 LOG” worksheet when the letter “D” is put into column D, any row, I need to have a message box with “ Do you want to copy to the Distribution billing sheet now” with a yes or no option. If Yes the data for that row in columns A, C, I, Q, S, and T then copied to the sheet “Distribution billing” to columns A thru F, on the next available row down. These need to be 2 separate worksheets located in our shared drive at “X:\SEA Shares\warehouse\container dock doors”

Thanks for all help provided.

Re: USD $30.00 Seeking totals by month, and working hours

Quote from KjBox;787149

In rows 9 to 20 on the Sea Log sheet the Stop Dates that are earlier than Received Dates for each of those quotes. Is that an error in the data or something that can actually happen?

This is an error in the example data. Thanks, this would never happen.

Re: USD $30.00 Seeking totals by month, and working hours

Hello KjBox, I had one other question on this, can the graph page be made to look like a power point? Or a full page picture?

Re: USD $30.00 Seeking totals by month, and working hours

Quote from KjBox;786953

I can look at this for you.

thank you!

Hello, $3.00 has been paid to [email protected]

For this project I need the totals, by month, from the data that is entered on the Sea Log Test tab, to populate to the table on the DATA Tab. Then also on the Graph Test Tab.

I also need the working hours to populate on the Sea Log tab as shown in the highlighted cells Example, when a user enters the information in columns P & Q. Our observed holidays are listed.

The Data in columns A thru Q is entered manually on the Sea Log Test Tab by users. I’m sorry if I am being too Vague, Please let me know if you have any questions.

Re: USD $30.00 For excel user form to enter, or edit, data.

Quote from KjBox;786916

OK that would be good.

If you update the Raw Data sheet with a few actual Customers and Carriers in the Lists plus some actual Load details in the Raw Data Table and attach it here, then I can make a nice clean version for you to start working with.

Good Morning, Hope you got some rest! Please have a look at the attached, and let me know your thoughts. Thank you.