mrxwantobe
Board Regular
- Joined
- May 2, 2002
- Messages
- 158
I have a fixed width file I am importing into Excel. It has 3 columns. "A" is a customer number ie 1004. "B" is customer name ie Tom's Auto and "C" is how much he bought from me this month. I would like to see his next month sales in "D". If I import the same report next month I will have duplicate cust numbers in "A" and "B" with next monts sales in "C". Is there any possible way to get those new numbers in "D" with the right customer and then delete the duplicat record?
Plese help if you can
Plese help if you can