Creating report for Excel data?

E

Elaine

I am new to automating Excel in any way. Is it possible to
create a report based on a spreadsheet?

This spreadsheet contains customer account information and
we want to send statements for a range of accounts. I
would need to get the range of account numbers from the
user in an input box or something and then grab the
applicable cells for each of those accounts. The report
would be one account to a page and list the customer name
and account balances.

Would be a snap in Access but is this reasonable to
attempt in Excel? Can anyone offer some guidance or web
sites that may be of use? Appreciate any input. Thanks.
 
G

George Nicholson

Would be a snap in Access

Is the workbook data set up in such a way that you could set it up as a
Linked Table(s) in Access and do your reporting from there?
 
P

PC Datasheet

Elaine,

I am in business to provide customers with a resource for help with Access,
Excel and Qord applications. You can view my website at
[email protected]. I can build an application for you that integrates
Excel with Access that would produce the reports you want. If you would like my
help, contact me at the email address below.
 
Top