Results 1 to 8 of 8

Macro to Total Volumes

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-16-2008
    Posts
    287

    Macro to Total Volumes

    Hi, i am looking to write a macro that will loop through a list of queues and then sum up the values for each queue from column S and AA from a different.

    I have attached a sample workbook that has 2 sheets. What i would like is for the macro to go through the list of queues on Column A in Volumes Sheet and then find these queues within the Source Sheet and if found sum up the values in Column S and AA and then put the value in Col D on Volumes Sheet, otherwise if the queue is not there then move onto the next cell.

    I am guessing I will have to write a for each loop but not sure where to start.

    Thanks in advance. Hope somebody can help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1