macro to copy data where the ID is equal to what is copied from another cell

Here's something that may get you started. It uses the vlookup function and checks to see if the value was found. I've made the example so that it just displays a message if it is not found, but you could modify it to ask for a value.

Please Login or Register  to view this content.

Soory for the delay. I was out of town. The approach that you want to take will only generate NA is the cells and you will be not able to capture them. Do you want to display a message after each vlookup?

Could you attach a workbook showing inputs and desired outputs. That would help us understand what you want a bit better. Don't include any sensitive data.

Originally Posted by blink359

If that cant be done is it possible to do a check box that changes the visibility of a button and turns a cell validation on/off, I have tried other things such as auto filter by copying the id of the cell but that didnt work either. Im not quite sure what else to do.

I'm getting closer to understanding this, but need to be a bit of clarification. I understand that if the customer ID is found, then the rest of the fields need to be updated. What is supposed to go in G18 in this case?

I have made an update to the VBA for the Inventory sheet, putting a WorkSheet_Change event handler. If the number number is changed in cell b15, then the existing customers is searched and the fields updated. If the customer is not found, then G18 is set to "Not Found".

I am not sure about what you want with the button and data validation. Let me know if what I sent you is close and we'll go from there.

I also had to comment out a coupld of lines in teh modules to get this to compile.Example.xlsm

There are many ways to learn VBA and I don't know what suits you best. There are many tutorials on Microsoft's MSDN web site. Here is one example. You can also use the VBA help to see what an individual sollction, object, property, method, or event handler does, either by searching on the name, or put the cursor in the word in the code and pressing F1. Hope this helps a little.