chris1234567
New Member
- Joined
- Sep 21, 2006
- Messages
- 12
I have a spreadsheet with 8 tabs accross the bottom
the first is called staff
the next six tabs are labelled a,b,c,d,e,f
What I require is when the number is column B on all 6 sheets starts with a T for example: T9777 would fit the criteria it will copy that whole row and place it on the next avaiable row on the first tab "staff".
I need it too look through all the B colums on all six sheets.
Can this be done without invloving VBA
the first is called staff
the next six tabs are labelled a,b,c,d,e,f
What I require is when the number is column B on all 6 sheets starts with a T for example: T9777 would fit the criteria it will copy that whole row and place it on the next avaiable row on the first tab "staff".
I need it too look through all the B colums on all six sheets.
Can this be done without invloving VBA