Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
"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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to copy and edit then delete a worksheet | Excel Discussion (Misc queries) | |||
help! making a worksheet more automated? | Excel Discussion (Misc queries) | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
copyright and worksheet protection | Excel Discussion (Misc queries) |