Search results for query: *

I have a complex formula, so I created cell labels to reference in my formulas. I think that this might confuse my co-workers and I would like to be able to convert back to A1 references. Seems like I have done this in the past and it was easy, but I can't seem to find this solution. Age or...

I had scheduled an important meeting and I wanted to copy and paste attendee tracking information into Excel to see the status of who had accepted, declined, or no response. I was very disappointed that Microsoft application help indicated that this could not be done...

I am having problems using vlookup and cell with named range to return value. If I manually put in the formula =VLOOKUP($B$4,'IFS Rates Sheets 6-01-05 2.xls'!National_Rate_Chart,VALUE($C$ 3+1)) the formula works. I would rather use =VLOOKUP($B$4,$C$2,VALUE($C$ 3+1)) with the cell C2 having the...

What is the best way to select and copy a column of non-contiguous data without copying the first row that contains a column heading? Thanks

I have a string variable Manager_Val that I would like to use in autofilter criteria .Range("A1").AutoFilter Field:=2, Criteria1:="<>(Manager_Val)" When I run the macro I am getting the actual name “Manager_Val”, instead of the value of the variable. How do I refer to the variable Manager_Val...