Hi there, I am hoping that someone can help me out, I would really appreciate it! (Please note that I searched through the forum for an answer and found something sort of similar but not close enough, at least not for me to alter it at my skill level!)
Here's my situation and what I need to do:
In several worksheets (all within the same workbook), I have a red flag column in which either the phrase "Price too High" or "Price too low" appears. If the price is not too outlandish, then nothing appears in this column. In each of the worksheets, the red flag column is always in column R.
I am trying to look through each of the worksheets and if either of these phrases is present, I would like to copy the Entire Row into a worksheet called "Bid Analysis Summary".
The worksheets in which I would like to look contain varying numbers of rows of data, some are hundreds of rows long, some only have a few rows.
Although I am quite skilled with IF forlumas and such, my knowledge of VLOOKUP and the like is limited.
I can do this either with a macro or a formula....I just want to make it happen at this point as I am hitting the wall on this project!
Thank you so much for your help, you guys are great
Here's my situation and what I need to do:
In several worksheets (all within the same workbook), I have a red flag column in which either the phrase "Price too High" or "Price too low" appears. If the price is not too outlandish, then nothing appears in this column. In each of the worksheets, the red flag column is always in column R.
I am trying to look through each of the worksheets and if either of these phrases is present, I would like to copy the Entire Row into a worksheet called "Bid Analysis Summary".
The worksheets in which I would like to look contain varying numbers of rows of data, some are hundreds of rows long, some only have a few rows.
Although I am quite skilled with IF forlumas and such, my knowledge of VLOOKUP and the like is limited.
I can do this either with a macro or a formula....I just want to make it happen at this point as I am hitting the wall on this project!
Thank you so much for your help, you guys are great