hi all!
I'm having some troubles with an excel thing and I can't get it figured out.. I'm affraid I might have to resort to VBA instead
Here's the situation:
sheet 1 (officially another workbook (1) but for convenience sake i made a demo sheet in the same workbook) holds ALL the data
sheet 2 (officially workbook 2) should only hold the data from sheet 1 where a cell in a certain column holds a speciffic value.
In the end people should only be able to look at workbook 2 so they can not look at the other data.
The problem is that there are rows in between that are not applicable and if I use a formula I will have rows reading "#N/A" or something along those lines.
Is there a way (formula or VBA) that can look op rows in a different workbook that hold a specific value in a specific cell in a specific column and copy certain cells from that row to a new workbook?
I have enclosed a dummy/demo workbook so anyone who thinks he/she can help can take a look.
Kind regards and thanks in advanced!
Target_0.xls
Bookmarks