Results 1 to 7 of 7

Thread: Auto filter and sum up data

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 01-02-2013, 10:58 AM #1
    Ryan_Bernal
    Ryan_Bernal is offline
    Member Ryan_Bernal's Avatar
    Join Date
    Dec 2012
    Posts
    37
    Rep Power
    0

    Auto filter and sum up data

    Can someone help me on this?
    I have 3 columns (Column A = Date,Column B = Area,Column C = Kg)
    I want to automatically copy the filtered data on column I (Report) and get the total area and total kg of the the same data (area total column,kg total column) .

    Here is the attached sample of my workbook:
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Filter, Split And Move Data For Each Month From Master Workbook To Individual Sheet
    By vivek09 in forum Excel Help
    Replies: 6
    Last Post: 05-20-2013, 10:06 PM
  2. Auto Complete for Data Validation
    By IJC in forum Excel Help
    Replies: 1
    Last Post: 05-15-2013, 09:30 AM
  3. Auto Unique List
    By r_know in forum Excel Help
    Replies: 8
    Last Post: 07-19-2012, 09:28 PM
  4. Extract data using Advanced Filter
    By PcMax in forum Excel Help
    Replies: 4
    Last Post: 01-02-2012, 02:31 AM
  5. Auto adjust for cells according to value using VBA
    By LalitPandey87 in forum Excel Help
    Replies: 3
    Last Post: 11-08-2011, 08:58 AM

Bookmarks

Posting Permissions

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

Forum Rules