shorten

Hi, The formula below is a lookup using multiple values. It works well however I feel as if it could be neater. I am also bordering on the nesting limits if I would like to add any additional formulae. Could you please help me shorten it...

How can i shorten this code? I think i can shorten the amount of If Else's to just one that does the same thing as what i have got but i dont know how to do this? Take a look. Sub Filterofcolumn() ' ' Filterofcolumn Macro ' Sheets("FolderSort").Select ActiveSheet.Range("A1").Select...

Hi guys and gals I have been a silent user of this site for sometime usually finding something close enough to my means that I havent had to post so far but I have now hit a (hopefully simple) snag. I work for a community organisation, one function of which is we distribute vouchers to those in...

I created the formula below that does the following: Display "Yes" if the address is For Sale, and if not, check to see if it's Vacant, and if so display "TRUE". Otherwise leave cell empty. I even have a working formula... Here's my sample data: Excel 2010 <tbody> A B C D E 1 DATA...

Hi Guys, I was wondering if I could shorten this equation but make it automatic. So that I can update my chart automatically...

Hey guys, need help on a very length code :eeek: I'm using Excel 2007. The way I programmed my Excel spreadsheet is: specific columns in a different worksheet ('Table') are hidden/shown according to answers in cells in worksheet 'Questions'. The code I included below is just a snippet of the...