Find last used row, delete un-used rows and total

  • Re: Find last used row, delete un-used rows and total


  • Re: Find last used row, delete un-used rows and total


    After looking closer at your project, here is an updated version that I believe will work better for you:




    [TABLE="width: 506"]

    [tr]


    [TD="colspan: 7"]Formula in B2, copied down : =IFERROR(VLOOKUP(A2,Sheet2!$A$2:$C$20,2,0),"")[/TD]

    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="colspan: 7"]Formula in C2,copied down : =IFERROR(VLOOKUP(A2,Sheet2!$A$2:$J$20,3,0),"")[/TD]

    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="colspan: 3"]Formula in D2 : =SUM(C:C)[/TD]

    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="colspan: 3"]Inventory Table on Sheet 2[/TD]

    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [/TABLE]

Participate now!

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