I asked a previous question but did not get the answer I was seeking so I am
restating the situation. Following is the situation and I am seeking advice
on the best approach to accomplish what I need.

I am using Excel 2003. I have a spreadsheet with about 150 columns and 1000
rows. I need to create spreadsheets that containing specific columns in the
€œMaster€� based on values in column P. In the €œMaster€�, I can create a dummy
column A and copy data from P to A. The €œMaster€� contains some confidential
data so I cannot simply hide columns/rows and then distribute the spreadsheet.

For example when I find an €œS€� in column A, I need J, K, DG, DF, P and
DI-DM, copied to a new (spreadsheet). Of the 1000 rows, about 100 contain an
S. I tried a vlookup, for an €œS€� in column but the new spreadsheet contained
900 zero value rows. I am graphing the new spreadsheet and the 900 rows with
no data are distorting the graph. Once the new spreadsheet is created, I
could manually manipulate the data, but I need to create several
spreadsheets. With the deadlines, I need the spreadsheets to as €œReport
Ready€� as possible.

I think the vlookup is a potential solution, but I can I avoid the zero
value rows. Any other thoughts/suggestions to meet the objective?

--
JPS