Search results

Works great! Thanks so very much!

Thanks! https://www.dropbox.com/s/3ww1teuvftzmrt9/Book1.xlsx In this example the summary page is missing code MNO. MNO is on sheet3 but not SUMMARY. With having a workbook w/ 50 sheets of ~100 rows of various codes each, and a SUMMARY page of 200+ rows of codes, I need a way to be aware of a...

Thank you for your help, however, it's highlighting values that already exist on the summary sheet and, as a constant, I added a value on a worksheet that i know does not exist on the summary sheet and it is not highlighting.

This might be an impossible task: I have a workbook with ~50 worksheets and then a summary worksheet. Each worksheet has a list of codes in column C and a dollar amount associated with it in column E. My summary sheet has codes listed in column C and then the combined total for that code from...

Wow, not sure how this works but it does! thanks!

I have a 2010 spreadsheet that uses VLOOKUP to pull $ amounts in multiple catagories. Each catagory is a column. Each row is the store being charged. The end of each row is the total cost charged to the store and the end of each column is an average cost of that catagory. I have used the...

Success! Sooo many thanks!!!

Thanks for your quick response. ?Range("Criteria").address "Run-time error '1004': Application-defined or object defined error" _______________________________________ The data validation list is "ALL, Plumbing, Electrical, Excavation, Carpentry, Masonry, Other" A4 is "Feild" and...

Ok, when I click through the drop down list options it works for every option including if I click ALL. But once I click ALL and then try to click any other options again to sort it an error comes up "Run-time error '1004': Mathod 'Range' of object_Worksheet' failed" and then this part is...

Thank you so much!! I see how you changed it and it worked! I just need to work more with these to understand the lingo... Your help is much appreciated!

I have a sheet of vendors and their contact info. I would like people in my department who have access to this sheet to be able to use a dropdown list to View All Vendors or View Vendors by Field. So far I have successfully used the different vendor field selections in a data validation list...