Autopop. data in Excel - an end to monotonous data entry?!

[gshadz37]

Hello,
I currently run several reports & queries against an Oracle database daily, then punch the numbers into excel spreadsheets. Can anyone tell me if there is a way to somehow autopopulate this data in the appropriate cells everyday?

The data I am pulling is from the previous day, so I'm not sure how I would use something like sysdate -1 in the query and prevent it from overwriting the next day?

Any help is greatly appreciated!

Thanks in advance.

 

[SkipVought]

Hi,

Autopopulate means many thing to many people.

If you are using native Excel functionality, there are features like PiovtTable, Sort, Filter, Subtotal, Chart, Query, that "autopopulate" reports/results.

Beyond that, you will have to code, using VBA.

What are your requirements?

Skip,

_[red][/red]

 

[gshadz37]

Hi Skip, Thanks for your reply. Here's an example of what I do:
Thur Fri Sat
RPAN 03/01/07 03/02/07 03/03/07
Volume of New Trouble Tickets 276 331 66
Ext. Ref Ave Hours RPAN 25.69 33.09 30.53
Total Tickets Closed 43 53 17
Tickets Closed in 24 Hours 40 44 13

Where I run queries using pl/sql developer then punch the results into a cell for that day. This is just a small sample. So I guess what I mean by "autopopulate" is, is there a way to query the database from each cell everyday and have the data for that day populate the correct cell. I hope this makes sense, I know what I want to do, but do not know the best way to go about it.

Thanks,
Gary

 

[SkipVought]

Why not a PivotTable?

Skip,

_[red][/red]