Condensing my worksheet
 

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.

"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.

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.

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.

Does anybody have any suggestions that might work?


"Derek Witcher" wrote in message
...
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.