Excel Reporting...

Scotteq

Plays with his WEI
Vista Guru
I have a small group of people in collections who spend their days creating and parsing out excel spreadsheets containing invoice status information. Customer, invoice, file number, amount, status (to be paid, processing, not received by customer, etc...), and various other bits of invormation. Creating these isn't so bad - essentially matching several data sources in Excel by invoice number with a V lookup or index formula.

However, parsing them out is a MAJOR time sink: Number of customers multiplied by the number of business units, local managers, and area controllers involved in each account.... And all of these people want slightly different views of their worlds.

I am looking for a tool which can use to design a report(s), then use a large~ish Excel Spreadsheet (a few hundred up to 15 thousand lines by 20~30 columns) to automatically create those reports for the different internal consumers. A near-perfect solution would also be able to use Outlook to automatically e-mail them out to pre-defined recipients with some kind of standard message: So the Area Head gets a message saying "Dear Sir, attached please find the bi-weekly...", with an attachment containing his report. While the guy in Operations gets "Yo Jackass, you didn't do your billing this month.... Again....", and his attachment tells him what he needs to get done. This would save DAYS of time.

Is anyone familiar with a product or tool like that?? I've been googling, but many/most of the products I've found so far seem to be a lot heavier duty than we actually need.
 
Last edited:

My Computer

System One

  • Manufacturer/Model
    Proudly Built by Me!
    CPU
    Intel Q6600
    Motherboard
    DFI UT LP P35 T2R
    Memory
    8GB OCZ Reaper DDR2 800 C44GK 4-4-4-12 2T
    Graphics Card(s)
    Sapphire Radeon 4870x2
    Sound Card
    AuzenTech Prelude 7.1
    Monitor(s) Displays
    1 Acer P243 24" and 1 Samsung T260 26" Monitor/HDTV
    Screen Resolution
    Both are running at 19x12
    Hard Drives
    Seagate 1TB 7200.11 (Vista x64)
    Seagate 500GB 7200.11 (Win 7 x64)
    PSU
    OCZ GameXtream 900w
    Other Info
    FSB at 400 (1600) Mhz, CPU Multi @ 8 for 3.2Ghz
I'm not that great with it, but from what I've seen, MS Access promises to do something like that. I'm not sure to the extent or anything like that, but the capability does exist. I have only started playing with Access; since I have no actual use for it, I'm mostly going through tutorials with no end in mind, so it isn't clicking for me that fast.

Another option would be to jump into the Visual Basic part of Excel and write code for it to do what you're talking about. I can tell you, though, that this is a bit time consuming for a non-dedicated coder. If you have someone like that in your office who has the job of writing support code, it may be worthwhile to give them as a job.

Maybe someone else will have something for you. Still, I would expect that Microsoft would include some capability like that in the Enterprise or Business edition of Excel. If you have Office 2007, it would be worth your while to look at Access as an option. Additionally, MS Groove, InfoPath, and OneNote may help streamline some operations.

Good luck.
 

My Computer

MS Access is definately the way to go.
 

My Computers

System One System Two

  • Operating System
    Windows 11 Workstation
    Manufacturer/Model
    doofenshmirtz evil incorporated
    CPU
    Ryzen 9 5950X
    Motherboard
    Asus ROG Crosshair VIII Formula
    Memory
    Corsair Vengeance RGB PRO Black 64GB (4x16GB) 3600MHz AMD Ryzen Tuned DDR4
    Graphics Card(s)
    ASUS AMD Radeon RX 6900 XT 16GB ROG Strix LC OC
    Sound Card
    Creative
    Monitor(s) Displays
    3 x27" Dell U2724D & 1 x 34" Dell U3415W
    Hard Drives
    Samsung 980 Pro 1TB M.2 2280 PCI-e 4.0 x4 NVMe Solid State
    Drive
    PSU
    1500W ThermalTake Toughpower
    Case
    ThermalTake Level 10 GT
    Cooling
    Enermax Liqtech 240
    Keyboard
    Surface Ergonomic.
    Mouse
    Logitech Performance MX
    Internet Speed
    350 Mb/s
    Other Info
    WinTV NovaTD
    HP CP1515n Color Laser
    Sony BD-5300S-0B Blu-ray Writer
    Microsoft LifeCam Cinema
    APC 750i Smart UPS
  • Operating System
    windows 10
    Manufacturer/Model
    Surface Pro 3
    CPU
    1.9GHz Intel Core i5-4300U (dual-core, 3MB cache, up to 2.9GHz with Turbo Boost)
    Memory
    4GB
    Graphics card(s)
    Intel HD Graphics 4400
    Monitor(s) Displays
    12" Multi Touch
    Screen Resolution
    2160 x 144
    Hard Drives
    128GB
    Mouse
    Logitech
    Keyboard
    yes
    Internet Speed
    350 Mb/s
Back
Top