Okay,
I'm kind of a newb when it comes to excel. My boss just sent me over this excel sheet that he wants me to try and fix. It is wonderfully broken down, but there are two problems with the file. The Excel sheet is a list of items, what they correspond to, and where they are located. Each item corresponds with multiple things like Vendor, Distributor, etc.
1) He'd like it so that each item is essential set up as a list. He has already created it as a list himself, but it doesn't do it automatically, so if we add a new item in one of the categories we then have to go through that whole category changing the numbers that follow that new item.
2) The second problem we are having is that the items are color coded from gray to white to gray. Every time we add another item, again we have to go through and change the other items so they follow the pattern.
Hopefully this all makes sense because I can't post the excel file since it is confidential. Please let me know what you guys think. I'm sorry for not searching, but I wasn't sure what to search for.
EDIT:
3) We also would love a way so that we could click "Vendor" and all the items that correspond are only in view. Is that anyway possible?
EDIT 2:
I think I figured out how to sort items by using AutoFilter, the problem is that it doesn't wont' work because it says some of the merged cells are not the same size.
The real kicker with the sorting is that items are in specific categories, so lets say I decide to put the items in descending order in stead of ascending like it is now, I would like the category title cells to movie as well so you can tell the item is still with that category. Possible?
I'm kind of a newb when it comes to excel. My boss just sent me over this excel sheet that he wants me to try and fix. It is wonderfully broken down, but there are two problems with the file. The Excel sheet is a list of items, what they correspond to, and where they are located. Each item corresponds with multiple things like Vendor, Distributor, etc.
1) He'd like it so that each item is essential set up as a list. He has already created it as a list himself, but it doesn't do it automatically, so if we add a new item in one of the categories we then have to go through that whole category changing the numbers that follow that new item.
2) The second problem we are having is that the items are color coded from gray to white to gray. Every time we add another item, again we have to go through and change the other items so they follow the pattern.
Hopefully this all makes sense because I can't post the excel file since it is confidential. Please let me know what you guys think. I'm sorry for not searching, but I wasn't sure what to search for.
EDIT:
3) We also would love a way so that we could click "Vendor" and all the items that correspond are only in view. Is that anyway possible?
EDIT 2:
I think I figured out how to sort items by using AutoFilter, the problem is that it doesn't wont' work because it says some of the merged cells are not the same size.
The real kicker with the sorting is that items are in specific categories, so lets say I decide to put the items in descending order in stead of ascending like it is now, I would like the category title cells to movie as well so you can tell the item is still with that category. Possible?