Help with VBA Problem

[Legacy 176914]

Hey all,

I was wondering if you anyone could help me solve this problem. Here is the description:


You have a spreadsheet with account information on customers. You have three columns: 1) The customerID 2) Amount the customer owes 3) The amount the customer has already paid.

I need to write a vb script that will find the difference between what the customer has paid and what the customer still owes, and if that value is above $1000, paste it in a separate worksheet. I also need to past the corresponding customerID next to it.

Any thoughts? Thanks in advance.

 

[venkat1926]

you can have a spread solution.

the sample data is like this
cust owes paid balance
a 3799 3799 0
s 2751 745 2006
d 4997 4900 97
f 1193 100 1093

the column D is introduced(balance)
D2 has formula
=B2-C2
D2 is copied down

cursor to A1
click data(menu)-filter-autofilter
there will be arrows in all the four column headings
click the arrow in column D

in the left window (click the small arrow)
choose greater than equal to
on the right window type
1000
click ok at the bottom

you will have filtered rows (two only)
highlight the filtered data and copy paste in any other location

again cursor to A1
click data-filter-autofilter
the autofilter mode will be removed.

 

[Legacy 176914]

Awesome, thanks! I appreciate the reply.