HELP: Need to use a value from another sheet as the criteria for a filter.

Hey All,

I need help with creating a macro. The code I have is currently messy and I will clean it up after I solve this but the bare bones of what I want to do is as follows.

selects cell A in sheet A --> go to another sheet B --> filter that sheet for the attribute based on the value inputed in cell A --> Copy all values in sheet B under Column B who shares an attribute in Column A which is filtered by cell A --> Go to Sheet A and copy column B values into sheet A. --> Conditional Formating and Look Pretty

The problem with the code is that when it gets to the part where it has to filter, instead of using the cell A from sheet A as the filter criteria it uses the text I had in cell A sheet A when I initially recorded the macro. I want this macro to be used anytime i change the values in cell A sheet A

PLEASE HELP!

Please Login or Register  to view this content.

Hi rgrocks ,

Can you attach a copy of workbook. You code is recorded and some information I cannot figuere out.

Thanks

I cant upload it onto the forum but here is a link to it on my dropbox

http://db.tt/LZDW5hab

Hi,

See if this code helps

Please Login or Register  to view this content.

Thanks alot, This is my first time using MACRO's so I just recorded my actions. I have no Idea how to create a macro using text. How do I create a macro using the code you sent me?

I found a way to do it. Not sure if its the proper way but it works!!! THANK YOU!!!

I know this might be too much to ask since you have helped me beyond words but I see you wrote comments in the code. Could you describe what is going on with greater detail so that I may learn and implement it in the future.

Also could you point me to a website to learn more?

Thanks again!

Use this website to search for each keyword I used in my code

http://msdn.microsoft.com/en-US/libr...ffice.15).aspx

I am glad I was able to help