How can I create a separate report. Autofilters works great but that
changes my main copy. I would like to have a separate copy with only the
columns needed.
"Peo Sjoblom" wrote in message
...
Sounds like you could use a filter
http://www.contextures.com/tiptech.html
look at the filters (auto and advanced)
--
Regards,
Peo Sjoblom
(No private emails please)
"Derek Witcher" wrote in message
...
"Derek Witcher" wrote in message news:...
I have a master sheet that has all of my current jobs that are finished
as well as the ones that are not complete. I have a column that states
finished that I insert a "x" in when complete. I am looking to use
something like a vlookup or hlookup of something that will allow me to
remove some of the columns that I am not concerned with and create an
easier to read schedule. I currently have 38 columns but I only need
about 10 for my schedule. Any suggestions? Thanks for the help in
advance. What I want is if(A1..A10000)=x leave it out of my report and
give me all of the other data.