VBA issue changing filter value. How would do I change across multiple sheets?

[punter]

Good evening,

I am having an issue with a workbook I'm putting together. The workbook is creating multiple sheets pulling data from various sources. I've got it working very well with the exception of a filter issue.

There is a sampling of data that is being put on each created sheet. I only want each sheet to have the data in question related to the value in cell K4. My thought was to simply copy the value out of K4 and then use the filter function to delete out everything that is not needed (see below).

Please Login or Register  to view this content.

The problem I'm running into is how to have the code pull the data for K4 on each sheet and not just use the same value (23959394-1) from the first sheet and repeat through the rest of the workbook.

I can work out everything else in regards to ranges and formats. I am having some difficulty cracking this one nut.

Any suggestions will be most welcome.

Thank you so much.

[AliGW]

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[punter]

I have changed the title to make it as specific as possible.

[AliGW]

Much better - thank you.

[AlphaFrog]

Please Login or Register  to view this content.

[punter]

That worked perfectly. Thank you so much.