Results 1 to 4 of 4

Formulas for referencing data from another sheet

Threaded View

  1. #1
    Registered User
    Join Date
    04-02-2008
    Posts
    59

    Formulas for referencing data from another sheet

    To begin with, this may be somewhat of an involved project and needs some visual explanation, so I have attached the workbook that I will be using as an example, so please take a look. I have a call report sheet named “Dec-08” and I would like the data from “Dec-08” to automatically populate a call frequency report, which will be on another sheet named “Call Frequency”. On “Call Frequency” I would like the cells in column A to look at column D on “Dec-08”, find the GIS #, then populate column A in “Call Frequency” with that #. But if the same # shows up more than once on “Dec-08”, I would like it to only be populated one time on “Call Frequency”. From there “Call Frequency” columns B:Y will look at what is in column A on “Call Frequency” and populate those cells accordingly from referencing the “Dec-08” sheet columns E, F, and L.
    Column B on “Call Frequency” will be populated with the corresponding account name from “Dec-08” column E.
    Columns C:Y on “Call Frequency” will be populated with the total hours of time spent at that particular account from “Dec-08” column L. If more than one contact , column F, was seen on the same day, the sum of those hours will shown for that day on “Call Frequency”. (May Be Tricky???)
    Columns Z and AA are all ready to go.
    If this doesn’t make sense then please let me know, otherwise thank you so much for your help, I owe you big!
    Lukas
    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