• 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. M

    Project Flight Calculator

    Hi vletm. The "Flights Required (return flights)" table only captures when a return flight is booked and paid ie C45. The "On-site Manning Levels per Roster Crew" table shows the number of men on site for each week on the project. So for roster crew 1, there will be 5 flights booked and paid...
  2. M

    Project Flight Calculator

    Thank you for your detailed response Peter. You lost me after "matrix equation"... I have had a look at your attempt and note that it has negative values (S24, T24 etc) which is not correct. I was also hoping to not rely on "helper" formulas although I understand if this is not possible. Would...
  3. M

    Project Flight Calculator

    Hi. I am trying to automate a spreadsheet to calculate manning levels per roster crew as per attached spreadsheet (range C24:V27). I have tried many types of formulas (COUNTIF, OFFSET etc) without much success. I'm thinking it might be too much for a formula given the variables involved. Any...
  4. M

    Data validation based on adjacent cell

    Thanks Bosco. Works well except for item 3 in your post. Is there any way that this formula could be applied to "Cable Schedule" sheet "Drum No" column? This is the field that is used to select an appropriately sized drum and it would be great to see metres left on drum when making this...
  5. M

    Data validation based on adjacent cell

    Hi. I need to create a dependant data validation list based on the adjacent cell value. I have done this before as per link below http://www.contextures.com/exceldatavaldependindextablesindirect.html This method however does not suit my requirement. My spreadsheet is attached and my requirement...
  6. M

    Delete Power Queries and External Data Connections

    My bad. It works fine now that I am back on the company network and the connections are active (they were inactive when I tested earlier). Thanks Chihiro!
  7. M

    Conditional Formatting of a Table using VBA

    Hi SirJB7. I followed this link and assume you are referring to the link you suggested at comment #13? This addresses part of my question but does not specifically relate to tables and table headers being used in code; is this possible?
  8. M

    Delete Power Queries and External Data Connections

    Hi Chihiro. Thanks for your reply however I am receiving an error message as follows; Compile error: Syntax error The following code appears in red; cn.Delete qr.Delete Any ideas? Matt
  9. M

    Conditional Formatting of a Table using VBA

    Hello. I'm trying to apply VBA to conditionally format a table as per attached file. Specifically, I would like to use the table header references within the code. I can do this manually via the ribbon however Excel has a tendency to fail with conditional formatting when you insert rows hence...
  10. M

    Delete Power Queries and External Data Connections

    Hello. I have a workbook that I use to create a report for our client. It has 5 sheets and each sheet has it's own Data Connection (DC), 2 from Excel files, 3 from our company's proprietary software ie a .rpt connection. I have written a macro to filter each of these DCs, copy and paste visible...
  11. M

    Filter based on cell value and then export results to new sheet

    OK. Thank you once again. I appreciate your help. Matt
  12. M

    Filter based on cell value and then export results to new sheet

    Thanks again Nebu. Still not quite there though. I've looked at your code and can see PasteValuesAndNumberFormats and then you have applied various other formats. Is it possible to paste everything except for formulas? This would then include all formats that I'm wanting ie numbers, alignment...
  13. M

    Filter based on cell value and then export results to new sheet

    Hi Nebu. Works great. Is there any way to export all formats as well? (numbers, alignment, borders and shading) I have split the description field on the Variations sheet because I need to add some data above the headers and need to align it differently. Due to this I have had to shade the cells...
  14. M

    Filter based on cell value and then export results to new sheet

    Hello, The intent of my spreadsheet is to use it as a 1 stop shop for pricing and tracking project variations. It is structured as follows; 1. Register - Summarises all data from Variations sheet 2. Variations - Data entry sheet to populate all variations information 3. Database - List...
  15. M

    Max date of each item

    Excellent. Thanks Hui. Matt
  16. M

    Max date of each item

    Thanks Hui. Works great. What if I wanted the last text entry against an item to be shown against all items ie replace all dates with text? Refer attached.
  17. M

    Max date of each item

    I need a formula to provide the max date of each item. Formula needs to be in Column C of attached spreadsheet. Thanks in advance. Matt
  18. M

    Transpose Timesheet Table into Database Format

    Thanks Asheesh. Works well. I have changed source data now but you have given me something I can work with. I might come back to you for some more help once I've further developed conditions etc. Thanks again.
  19. M

    Transpose Timesheet Table into Database Format

    I have an Excel table for entering timesheets into which needs to be converted into a database format for uploading into our accounting software. I have attached a file to show you what I'm after. Thanks in advance. Matt
  20. M

    Find MIN and MAX of numbers and text

    Hi Narayan, Perfect. Thanks again. Matt
  21. M

    Find MIN and MAX of numbers and text

    Hi Narayan, That's correct. Formula would need to account for Drawing No's being in random order as you mentioned. I am using your previous formulas so maybe these might help you with a new formula to do this new task. Matt
  22. M

    Find MIN and MAX of numbers and text

    Hi Narayan, Is there a way to create a Sequence No against each Drawing No so that you can keep count of how many revisions? For example; Drawing No Sequence No (or Count) 123456-A 1 123456-B 2 123456-0 3 123456-1 4 123456-2 5...
  23. M

    Find MIN and MAX of numbers and text

    Hi Narayan, Excellent work! You are a true Excel Ninja! :) Thank you so much for your help. I might have some more queries as this is only the beginning of a very complex spreadsheet... Thanks again Matt
  24. M

    Find MIN and MAX of numbers and text

    Hi Narayan, If there is no earlier revision of a Drawing No, then output should be "-". Matt
Top