Creating report for Excel data?

  • Thread starter Thread starter Elaine
  • Start date Start date
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.
 
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?
 
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
(e-mail address removed). 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.
 
Back
Top