Hi,

I have spreadsheet with following.

The "Details" tab contains almost 200 customers names & acct number along
with information for four different products (4 columns) which are sumed at
total monthly
the "Summary" tab has to show customer with total dollar amount monthly
which I as of now am linking it manually.


The summary tab has the customer names but needs to pull information each
month from the detail tab monthly, is there a way to automate this?

please advise

thanks for help in advance
TJ