LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Importing data from daily worksheets into my annual report

Ok, I am very much a beginner when it comes to working in Excel, so please
keep that in mind when replying.
How can I input specific data from a month's worth of spreadsheets into my
annual one?
I use excel to maintain call logs for three different departments, keeping
track of who calls, and walk in traffic for them. At the end of the day, I
have been taking those numbers and inputting them manually into my annual
speadsheet. I just add them to the subtotal for the previous day and so on.
Specifically, it's data from only four cells from my original workbooks
(each day's logs.) How do I do this? The four cells are in different
locations on the daily reports,according to call volume, and I want to them
to feed into the annual report without me having to manually enter the
numbers form each day and adding them to the rest of the month's data. (kind
of defeats the purpose of using excel if I can't, right?)

I'm hoping I've said this in a manner that makes sense, If not I am more
than willing to work with someone to get it right.
Thank you for any help.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to Open Daily Report KurtB Excel Discussion (Misc queries) 2 September 9th 08 02:14 PM
Combine daily data from different worksheets Rhino721 Excel Worksheet Functions 3 September 5th 08 03:39 AM
Annual gifts received report setup Babe Setting up and Configuration of Excel 1 June 24th 08 02:15 AM
daily cash report dave Excel Worksheet Functions 1 October 16th 07 04:44 PM
annuity with daily compounding but annual deposit of money Marjory K Excel Worksheet Functions 2 January 3rd 07 07:35 PM


All times are GMT +1. The time now is 04:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"