malgorzata
New Member
- Joined
- Feb 2, 2018
- Messages
- 4
Hey,
I've been looking for the answer to my current VBA issue, but couldn't find anything. Maybe someone in there knows how to solve the crisis.
I have two Excel files - one Workbook contains all the information on current/past/potencial clients[ALL CLIENTS'], and another one for just the potencial clients [PIPELINE].
I would like to copy the rows [from ALL CLIENTS] - if in "status" (coulmn F) cell appears "pipeline", and if cell (column K) contains "in progress" - and paste it to last rows of [PIPLELINE] workbook.
Do u know how this makro should look like? I'm quite new to VBA.
Thanks a lot in advance!
I've been looking for the answer to my current VBA issue, but couldn't find anything. Maybe someone in there knows how to solve the crisis.
I have two Excel files - one Workbook contains all the information on current/past/potencial clients[ALL CLIENTS'], and another one for just the potencial clients [PIPELINE].
I would like to copy the rows [from ALL CLIENTS] - if in "status" (coulmn F) cell appears "pipeline", and if cell (column K) contains "in progress" - and paste it to last rows of [PIPLELINE] workbook.
Do u know how this makro should look like? I'm quite new to VBA.
Thanks a lot in advance!