westallismiles
New Member
- Joined
- Feb 13, 2013
- Messages
- 20
I have a spreadsheet with 21 columns. What would be the easiest way to search column I for the word 'pending' and when that word is found to return the entire row to another sheet.
Along with that I also need to return only columns b,c,e,f,g,i,j,k. I also don't want to return rows that have certain number data in column C, that number data can range from 2-4 digits long.
Along with that I also need to return only columns b,c,e,f,g,i,j,k. I also don't want to return rows that have certain number data in column C, that number data can range from 2-4 digits long.