Search results for query: *

I can see the string.. it never says "in progress".. the thing is... nothing is pasting or appearing in the master sheet... as though it never finds "in progress

is wksName a string? I have option explicit going on

I'm sorry.. I'm really slow.......... the dropdown box is created using the Validation command under the Data menu in EXCEL and the choices just refer to a range that i put in some range way down in column T which is no where near the data im looking at.

the dropdown is all down column B... so B4, B5, B6 etc...

i honestly don't know what underlying cells are. each cell (for each sheet other than the master) starting from on column B4 has a drop down menu attached to it with 4 options... "in progress" is on of the options.

If the "in progress" part is in column B (not A).. do i just change it to wksSheet.Cells(lngInputRow, 2).. hmm... when i F8 the code to run through it.. it never gets past "If strColumnA = "In Progress" Then".. just loops back to the Do part...

Also... If the "in progress" is a result of a choice in a dropdown menu... is it still considered a string?

Thanks soo much! So this indexes all the rows with "in progress" in column A.... I still have to do a copy paste somewhere?

Im writing a code which lookings through each sheet in a workbook… and if the value in column A is "In Progress", then I need that entire row copied and pasted into the "master" sheet and then continue looking down the row… and then onto the next sheet.. I'm not even sure where to start. Can...