Consulting

Results 1 to 4 of 4

Thread: filtered data and named range

  1. #1
    VBAX Regular
    Joined
    May 2008
    Posts
    48
    Location

    filtered data and named range

    How can I add data to an existing subtotal filtered total in a cell from another worksheet by criteria? I have another sheet with additional premiums that I want to include in the premium based on the value of column A.

    I’ve tried using name ranges but they are not working properly because of the filter. Any suggestions?

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,232
    Location
    Yes, post a workbook and tell us which ranges etc., it might make it clearer.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Regular
    Joined
    May 2008
    Posts
    48
    Location
    Thanks,

    I've attached a workbook..I need the premium (column E) on sheet1 (data1) to also include the premium (column E) from sheet (data 2).

    Please let me know if you have any questions.

  4. #4
    VBAX Regular
    Joined
    May 2008
    Posts
    48
    Location
    Can someone please push me in the right direction.

    Thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •