Hi there and thanks for your time and help with my problem.
I am trying to find the best way to automatically copy and paste an entire row to a new spreadsheet if the text in one of the columns meets a certain criteria.
To further complicate the process, I have identically formated lists (the tabs are separated by different companies) on multiple tabs that I'd like to be consolidated on this new spreadsheet (if it meets the criteria).
For example: In the rows of my spreadsheets (they are all formated identically), are names, positions, and a series of codes. I want excel to automatically identify all the rows in each spreadsheet that has the code "QB" in column K and consolidate them (each row) onto a new spreadsheet.
Is this possible? Thanks again for the help.
Matt
I am trying to find the best way to automatically copy and paste an entire row to a new spreadsheet if the text in one of the columns meets a certain criteria.
To further complicate the process, I have identically formated lists (the tabs are separated by different companies) on multiple tabs that I'd like to be consolidated on this new spreadsheet (if it meets the criteria).
For example: In the rows of my spreadsheets (they are all formated identically), are names, positions, and a series of codes. I want excel to automatically identify all the rows in each spreadsheet that has the code "QB" in column K and consolidate them (each row) onto a new spreadsheet.
Is this possible? Thanks again for the help.
Matt
