# Dont know where to begin

#### Triton225

##### New Member
Hey guys. I am having a hard time with this. I have a project that I am working on, its just a simple list of folks who make purchases, who they are, what they paid....... Each person is given a purchase number, and they are in consecutive order. So if a person made a purchase today, lets say they are number 5, that same person could make another purchase a few weeks later, and the number would be, lets say 66. So there will be duplicates obviously if the person orders more than once.

Here is the problem...

I have a column for bounced checks. So if the customer gives us a bad check, i will put an 'X' in that column. My boss wanted to know if it is possible, while entering a person, could there be an alarm or pop up that will tell us that this person in the past has given us a bad check.

So, lets say someone places and order today, check bounces. A month from now they make another order, I type in the name... Can an alert pop up saying this person bounced a check on us a month earlier?

### Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

#### shemayisroel

##### Well-known Member
Tritton225 Hi & Welcome,

Sounds like there may be a few types of different solutions for your problem, could you post some sample data using excel jeanie in order for the solution(s) be tailored to your data.

http://www.excel-jeanie-html.de/index.php?f=1

#### jfklbj

##### Board Regular
Something similar to this might work

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
name = activecell.value
With Sheets("Test").Range("D13")
nitems = Range(.Offset(1, 1), .End(xlDown)).Rows.Count
If Intersect(target, Sheets("Test").Columns(5)) Is Nothing Then exit sub
For n = 1 to nitems
if Range(.offset(n,0)).Value = "x" and Range(.Offset(n,1)) = name then
End if
end with
next n
end sub

Last edited:

Replies
1
Views
320
Replies
0
Views
460
Replies
0
Views
1K
Replies
3
Views
927
Replies
1
Views
104

1,190,614
Messages
5,981,944
Members
439,745
Latest member
thepasmiths

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back