• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    Excel 2010 user form request

    Hello Monty, thanks for looking at this. I don't have much on it as this is a new project for me. Here is a file that could be used for history. I don't know much about user forms, so please let me know if you need more information.
  2. S

    Excel 2010 user form request

    Hello, I need to get An Excel User form created with the following Fields. Please see the attached Photo as an example of how I would like it to look. This Information would then save to another sheet for history and records. Please let me know if you have any questions, or Ideas on how to...
  3. S

    move certain data when certain column is updated

    Hi Vletm, I was able to get it working as needed after a couple of searches on line, here is the working code - Thanks for your help. Private Sub Worksheet_Change(ByVal Target As Range) AY = Target.Row ax = Target.Column If ax <> 12 Then Exit Sub With ActiveSheet If...
  4. S

    move certain data when certain column is updated

    Hi, Yes it is normal for the user to change the status Column randomly. Only when it changes to the " EMPTY" status, will it need to copy to the Distribution tab. The Column D will be updated, with the letter D before the status changes to Empty. It will change to empty only once. Make sense?
  5. S

    move certain data when certain column is updated

    One question, is there a way to have it copy only when a user changes the status to "Empty". It seems to copy on all status changes if the letter is present. Thank you
  6. S

    move certain data when certain column is updated

    Thank you much vletm, this is what was needed and will work great. Appreciate your time and code! Have a nice Day.
  7. S

    move certain data when certain column is updated

    Hello, on the attached worksheet when Column L, in the 2017 LOG tab is updated to “EMPTY” If there is the Letter “D” in any row, column D, I need the information from that row in column’s C, A, I, to copy to the Distribution Billing tab to columns A, B, C. Column D on the Distribution Billing...
  8. S

    Code needed to group matching data and create separate sheets based on that data

    Thank you Hui, I think I can get what I need going with the Split-Into-Many example.
  9. S

    Code needed to group matching data and create separate sheets based on that data

    Hello, On this worksheet I am get trying to get a Code that will group the different Booking #’s (Column I) and copy the data to the cell’s on the Invoice tab. So in this sheet there would be 13 different invoice sheets created, as there is 13 different Booking Numbers. Some have only one...
  10. S

    VBA to copy header row and post in email, excel 2010

    Hello, On the attached sample worksheet when Column A changes to Delivered it creates an email to send to the name selected in Column Q. It copy's the selected row (Column A - F) and pastes in the body of the email. I need to get row 1 - A thru F to copy and paste above the row in each email...
  11. S

    VBA or Formula? to assign a Zone based on driving miles

    Thank you very much Hui, This is working for me. I was using an index, and Match, but could not get it to work right. I appreciate the formula!
  12. S

    VBA or Formula? to assign a Zone based on driving miles

    Hello, I have a Code that i found online and am using to get 'google distance' for driving miles between 2 zip codes. I am trying to get a VBA, or cell formula, to assign a zone number for every 5 miles in distance. Please see the attached, Cell B6 would be where i need this to populate. This...
  13. S

    move data from one sheet to another by month entered

    Thank you Nebu, i appreciate your time putting this together. I will play around with it the next few days.
  14. S

    VBA code to move data based on masterbill

    Hello PCosta, Thank you for this. This will work for what I need! I appreciate it!!
  15. S

    auto copy data and send email when name is clicked

    Hello, On the attached worksheet, i'm looking for a code to copy the row A thru E, Including the Header row 1, (Columns F-P do not need to be included). and email that information to the User listed in Q and email address in R, When I double click on the Name. This would run through the month...
  16. S

    move data from one sheet to another by month entered

    Can you help with tweaking the code? I'm not very advanced on codes. Please let me know.
  17. S

    move data from one sheet to another by month entered

    Thanks Nebu, i could not find this earlier, Appreciate it.
  18. S

    move data from one sheet to another by month entered

    Hello, on the attached worksheet i'm trying to get the data from "Closed Business" to The "Executive" Sheet by month, when the Month is entered into cell J2, (I entered the first row in as an example) This would then save as "Closed Business for Distribution - October, 2016" , or whatever month...
  19. S

    VBA or Formula to populate network hours worked

    Thank you Nebu, I got it working.
  20. S

    VBA or Formula to populate network hours worked

    Hello, I have a sample spreadsheet attached that i need to get the working hours to populate in cell S2, Start date and time is P2, stop in Q2. Our holidays are listed, and the work week is Monday thru Friday 0800am to 5pm. and this will run throughout the year. Any ideas? Thanks for all help...
  21. S

    code to populate storage amount due after certain date

    That seems to work great. Thank you very much, I had a whole bunch of =if statements and it was very messy. I appreciate your time.
  22. S

    code to populate storage amount due after certain date

    Hello, On the attached workbook i'm needing to have the storage rate populate in the storage field. this would stop calculating, and keep the current amount, when the p/u date is entered. Rates are highlighted. and would start calculating by the Devanned Date. Any ideas on this would be a great...
  23. S

    VBA code to move data based on masterbill

    Hello, In This Workbook each master number can have 10-25 house bill numbers. There is about 8-15 master bill's per week. I'm trying to get to where after I enter the first master bill number, like in the example attached, have the data populate, then move down one row, have the same header and...
  24. S

    move data from a master sheet to multiple tag sheets for printing

    Works just like I needed it to! Thanks.
  25. S

    move data from a master sheet to multiple tag sheets for printing

    Hi Again Nubu, I'm getting an "object doesn't support this property or method" error after changing from print preview?
Back
Top