Needing a macro to Find, Select, Copy if...

[bjc124]

I have data in Columns A:H and I'm wanting a macro to select data in columns A:C if it finds "Route 11" in column D and "Scheduled" in Column G and do nothing if nothing meets the criteria.

I'm wanting the macro to be tied to a Button and I'm wondering if there is a way to turn the button bright green if there is data that meets the criteria to be copied and the button to be red if there's no data that meets the criteria, so the user doesn't waste their time clicking the button and trying to copy nothing.

I've included a test file as well if it helps.


I have also posted the following question here: https://www.mrexcel.com/board/thread...py-if.1146925/

[alansidman]

Which tab are you searching as I find no tabs with data in Column G. Which tab should the data be copied from and where should it be pasted. Really need you to be more specific in your ask and show a before and after (and indicate which is which). We are not mind readers here and only you know what you want. The rest of us need to be told.

[bjc124]

I just update the test file in the Original post, not sure why there wasn't any data there.

I'm searching the "Hauls" tab and I'm just wanting to have the data copied to the clipboard as is it will be pasted within another application.

Column A Header - Name
Column B Header - Date to Haul
Column C Header - Time To Haul
Column D Header - Route
Column E Header - Location
Column F Header - Hauling Company
Column G Header - Status
Column H Header - Notes

I'm needing a Command Button "Route 11" that when clicked it will search all the rows in the worksheet where:

Column D = "Route 11" & Column G = "Scheduled"

and then select and copy columns A:C of those rows


As far as the Command Button Goes if just wanting it's color properties to be dependent on if the count of: Column D = "Route 11" & Column G = "Scheduled" > 0

[alansidman]

You can attach this code to a button.

Please Login or Register  to view this content.

[dangelor]

Possibly...

Please Login or Register  to view this content.

[alansidman]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

[bjc124]

I updated my post with link to the other question.