davies wrote:
> I have a excel file with 8000 rows. It is an worksheet of AR invoice
> aging.
> I want to be able to create spreadsheets for the following. 1. Total
> Company Aging - (summary of this spredsheet) 2. Summary Aging per
> Customer # (summary of each customer) I have a total of 400 customers
> in this file. I don't know how to use VGA - just formuals. I can go
> the vlook ups, but I am just a beginner with those. Any
> suggestions/ideas as to how I can manage this data? If you have
> other ideas I would like to hear them. I know someone out there has
> done this before. At my old job I had some programers that could do
> this for me. Here I am that person if I want the report. HELP!!
> Thanks!
> EX: these are the column headings that I have. I have to manually
> age into the correct column because the system can't do it.
> Customer Name AR # Custome Service# Invoice Date Invoice Total
> Invoice# PO# Invoice Terms Due Date Current 1-30 31-60 61-90 91-120
> >120

Hi Davies,

maybe you could upload an example file to www.savefile.com


--
Thanks in advance for your feedback.

Ciao

Franz Verga from Italy