Alert User of Duplicate Entry

I am looking to add to the begining the VBA below. The goal is for the code to first check if the data in cell A4 (on "Tracker" tab) is listed anywhere in column A on the "Store" tab and if there is a match, provide the user with a message that says "Already Entered" and stop the macro. If there is not a match, proceed... Help!

Please Login or Register  to view this content.

I thought of another idea in case this makes solving any easier. We could use a dummy cell (eg X1) on the "Tracker" sheet that has the formula countif(Store!A:A, A4). Then, the code could say, "If cell X1>0, stop the macro. If not, proceed.

I am not trying to confuse the issue, but this could be part of one solution. Thx again,

You need to be sure edit OUT all the selecting and activating in your macros, it slows things down and is unnecessary. Put your sheet names into variables at the top of your macro, then address the ranges fully throughout the macro using the sheet name variables to move values instantly.

This macro I "think" does what you want. There was an A4 copy and an A8 copy at the top of the macro that didn't actually go anywhere. So that might need looking at, but this is to show you a better syntax.

Please Login or Register  to view this content.

You can disregard my last message if you even saw it. This is working very well, thank you. I ran the old macro by mistake.

I spoke too soon. Cell A4 on the Tracker sheet is linked to cell A1 on the Store sheet. This causes a problem when a search for cell A4 (tracker) is done on column A of the store sheet. I changed the range from A:A to A2:A2000, but there is still an issue. What am I missing?

Aside from not wanting to duplicate records, cell A4 from the Tracker sheet is pasted into collumn A on the store sheet and the same is done for A8 on the Tracker to collumn B on the store sheet. Clearly Beau saw what I was trying to accomplish but I am adding this because my guess is that the linking was inefficient. Sorry if I have confused anything. Just ask and I'll clarify. Thanks

Got it. Just needed to delete the two links I had in A1 and B1 on the "Store" tab and change the code to what's below (the only change was making A1, A4 and B1, A8. THANKS AGAIN!

Please Login or Register  to view this content.

One last thing, I forgot to insert the variable at the WITH instruction, so change this:

Please Login or Register  to view this content.

Now the sheets you define in the first two lines of code filter all the way through the macro without having to edit anything else.