suming up old customer numbers

  • Thread starter Thread starter brianwa
  • Start date Start date
B

brianwa

Hello all,

I have a situation where we have had a group of customers (40 or so
who have joined a central buying group.

The problem is that our system will not transfer their histoical sale
over to the new customer #.

What I want to accomplish is to sum up their 2003 sales when their ne
customer number shows up but it needs to recognize their old custome
number.

I hope this makes sense.

B
 
Hi
if you have a matching table you can assign the new customer number to
the old data using VLOOKUP. But without providing some sample data from
you (plain text - no attachments please) quite difficult to say what
exactly would help you :-)
 
Back
Top