Throughstream
New Member
- Joined
- Dec 9, 2016
- Messages
- 34
Hi I have the following set up for an annual leave style spreadsheet.
Sheet1
I would like to copy into sheet2 only the rows that have A under the name, is there a formula or do I have to use vba.
Cheers
Dave
Sheet1
![31167965360_54bc17fd22_b.jpg](/board/proxy.php?image=https%3A%2F%2Ffarm1.staticflickr.com%2F700%2F31167965360_54bc17fd22_b.jpg&hash=2a6c21fd251fcc334f14d956275eebbb)
I would like to copy into sheet2 only the rows that have A under the name, is there a formula or do I have to use vba.
Cheers
Dave