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

Hi Franz what is savefile.com? I am not familiar with that. - Davies

"Franz Verga" wrote:

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

davies wrote:
Hi Franz what is savefile.com? I am not familiar with that. - Davies

it's a site for uploading files and sharing them. In this way you don't need
to attach the file, just post or e-mail the link...


"Franz Verga" wrote:

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

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy