Copy cell value and paste into filter macro

Hi

Why don't you use the advanced filter which allow you to specify a criteria range and you can then set the container code and the item number.....

rylo

Hi,

I can get the result I want by doing using auto filter, which would be simpler than using the advanced filter but I am after a way that would act like a hyperlink that automatically filters the rows. So I came to the conclusion a macro would be easiest but it isn't quite working how I want it to, So I want to be able to do all this in a macro, so there is as little repetitive process as possible.

I appreciate your help but do you have any other suggestions?

Benno

Hi

Where in sheet1 is the value you want to filter by? In a consistent place and if so where?

rylo

The values I want to filter by are in Sheet1 column B only.

I then want to use these values to filter Sheet2 column F.

Have you got an idea?

Hi

So you have a list of values in column B, and you want to filter by each of these values in turn? What do you want to do with the results of the filter?

Perhaps you should build an example file and attach to the post so we can see what you are working with....


rylo

Hi,

I have attached a very basic format of what I want.

I want to be able to click (or run a macro) on a container number (Sheet1) and be redirected to Sheet2 where a filter has been done for that container number.

EG If I clicked on MSCU in Sheet1, I want it to show what I have done in Sheet3 (as an example) but in Sheet2.

As a hyperlink does not do this, I created a macro (see my first post). By using the macro, I would select the container number I wanted to filter Sheet2 by, then run the macro which copies and pastes but it does not register this as a paste but what text it is recorded with.

I hope I'm not confusing you any more than I already have.

Thanks for your help thus far.

Hi

In a general module in your example file, add the code

Please Login or Register  to view this content.

Now go to sheet1, select cell A6 and run the code.

Go to sheet2 to see the output.

HTH

rylo

THANK YOU VERY MUCH!!!

This is great, I've modified it a bit to select Sheet2 and the cell A1 so i can see it all at the click of a button, without having to scroll up. But this is excellent!! I appreciate your help and patience.

Thanks again