Announcement

Collapse
No announcement yet.

Excel Spreadsheet Help

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    Excel Spreadsheet Help

    I'm trying to do something in Excel which is proving a bit of a challenge, but I bet there's someone out there who knows how to do it really easily, so any help would be appreciated.

    I've got a bill of quantities in a worksheet - a list of itemised products with unique part numbers and prices. From this list I would like to specify a quantity of some (but not all) of the products, and then pull all the ones that have a quantity value greater than zero into a fresh worksheet which will then become and estimate/invoice.

    There may be several hundred items in the bill of quantities, and a typical estimate/invoice might include 5 individual items as an example.

    How do I get Excel to extract all the rows from the list that have a quantity greater than zero and list them in a fresh sheet on their own?

    Thanks.
    JR Vibe Fifty fb (YS56)
    Tags: None
  • #2
    if match vlookup

    Steve
    Steve...

    Outrage RC Field Rep


    Now enhanced with some more EGS's....

    Comment

    • #3
      Or create a Pivot table and you can pop in what you like :)
      Very Proud Owner of 1 EGS!!!!
      _____________________

      Comment

      • #4
        If its a one-off extract, just highlight the whole sheet, activate "Auto Filter" (on the Data tab of older versions of Excel, fook knows where on MS 2007). This will place a down arrow above each column, click on this will enable you to select only zero values, from the modified sheet, select all the rows (click on first row, then shift click the last row), and copy whereever you like.

        Just re-click on the down arrow you used, to reselect all, and the sheets will re-display all records.

        Pivot tables. . . . . . .that's for sad accountants only, who have hours to read and understand the Help text ! :)
        Janek

        Why does it always persist down at weekends ?

        Comment

        • #5
          I would do it like Janek, just apply and auto filter and deselect zero values

          Comment

          • #6
            Yep, found the filter function. Just need to apply it to the quantity column only and the select all values greater than zero.

            Good job. Thanks.
            JR Vibe Fifty fb (YS56)

            Comment

            • #7
              just highlight the quantity column and then select autofilter, then select all and deselect the zero value

              Comment

              Previous template Next
              Working...
              X