I am using excel 2008 and I can not figure out how to sort by fill color. Thanks for the help.
I am using excel 2008 and I can not figure out how to sort by fill color. Thanks for the help.
See if this helps
http://www.datapigtechnologies.com/f...rtonColor.html
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi everyone!
I'm sure you get asked this often but I can't find what I'm looking for on the internet so I'm asking and yes I'm a new-be! No laughing
I have a spreadsheet of 9 cells across A4 - I4 (white)and around 900+ down (but will be adding to this number and that's where you all come in...). It'a a list across of company names, legal name, street address, city, state, zip, phone numbers, website and business type. I want to be able to pick a cell like A3 (green) to entering all new info across then click a cell preferably A1 (blue) to be formulated to "Auto Sort" where it will put the row alphabetically down where it below...simple right? I worked off a spreadsheet at my previous job and can work within it, but have no idea how to create one?
Can you help?
Nardi
Screen Shot.jpg
Hi Nardi.
As with your other post, this one also breaks one of the forum rules..
Some people would probably argue that this also breaks the duplicate thread rule, but as you didn't start ether of the threads I would be inclined to disagree.2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread. You may include up to 3 links to other URLs in a single post, no more, so only link to the relevant pages.
If you start your own thread in line with rorum rules I'll post a couple of suggestions for you, no doubt some of the other members will have some alternative ideas too.
I can't figure out where to do that, post? Can you tell me where?
Click on the big 'Excel Forum' logo at the top of the page, then click on 'Excel General' in the forums section.
There is a button at the top that says 'Start new thread'
Thank you, I would never have found it on my own!
Nardi
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks