2 days in a row I have had to ask a question. I have spent most of the day looking thru already answered questions but, I can't find exactly what I need.
THANKS in advance for the help!
I have 2 worksheets one has list of store numbers in column A column N has a reason code for every store listed in column A. I need to bring the store number to a separate sheet based on the reason of County Ordered (or whatever word it might be) I need the numbers in my second work sheet to be on consecutive rows and not skip rows.
I have a screen shot that might help if my question is a little crazy.
This is the original report if the reason in Column N is "County Ordered" I need the store number in Column A to populate on a second sheet. Notice there are lots of Hurricane Isaias but, I need that first row on the new sheet to be the store number for "County Ordered" (row 19) on the first row in my spreadsheet and not skip rows with store numbers that do not meet my criteria.
THANKS in advance for the help!
I have 2 worksheets one has list of store numbers in column A column N has a reason code for every store listed in column A. I need to bring the store number to a separate sheet based on the reason of County Ordered (or whatever word it might be) I need the numbers in my second work sheet to be on consecutive rows and not skip rows.
I have a screen shot that might help if my question is a little crazy.
This is the original report if the reason in Column N is "County Ordered" I need the store number in Column A to populate on a second sheet. Notice there are lots of Hurricane Isaias but, I need that first row on the new sheet to be the store number for "County Ordered" (row 19) on the first row in my spreadsheet and not skip rows with store numbers that do not meet my criteria.