I'm not exactly a new user, but this is the first time in a while that I've
had to apply this knowledge to my professional duties. The spreadsheet I'm
working on is considerably large and I need to retain rows that contain
certain text or specific criteria. For example, I only ...

I am trying to programmatically insert a hyperlink into a cell on
sheetA (static name) from various other workbooks whose names all
differ. I want to be able to open the referenced sheets from a master
sheet. I tried to record a macro that copies and pastes as a link,

Hello.  How do I change the default folder for Data Sources queries?
When I click on Data->Import External Data->Import Data...,
it always defaults to "My Data Sources" in "My Documents".
I want to change it to a different directory!

Is there any way in Excel to have one field that outputs something like this
The configuration you chose was "=A1".  It has "=B5" hard drives totalling
"=B5*750" TB of data storage.
I am looking for excel to dynamically replace what is in quotes with the

Perhaps this is a Bob Phillips specialty. My testing has indicated
that this returns one, zero, or negative one:
1 All in range have condition(s).
0 None in range have condition(s).

Does anyone know of a plug-in or program that can compare two same-named
XLS worksheets to compare differences in the cell data? Is there any
freeware or low-cost shareware? Thanks.

I need to run a VBA code, but before do it, I would like that excel
analyse the data ( I need to verify it in a range, for example
"A7:A65336" or/and "D6:IV6"): if there is some duplicate data in this
range, then:

I'm attempting to type in a number and it is headed by 3 zeros. Excel keeps
converting to whole numbers. I need the number to be displayed exactly as I
typed it. Thanks in advance.

I have a file in Excel 2007 (in 2000-2003 format) that has ~25000 lines with
2 columns and NO FORMULAS. My arrow keys move like they are stuck in the mud,
and page-up and page-down delays a few seconds before moving. Filesize ~9MB.
I have another ~26MB file with thousands of ...

I have a Fuel tax log that is broken down by states.  If I do not fuel in a
state that has mileage i receive the error #DIV/0!.  I know why I have this,
I was just wondering if there is a format to blank this error.  I tried
setting my Display cell errors to blank but that did ...

Can someone please tell me the clear procedure of pulling specific data that
meets a certain criteria from one worksheet to paste on another. It's a very
large document and it would require alot of sifting. I don't have much time.
Please help me. Also, once the data is pulled, ...

For my project-database (excel) I use the wonderful solution mentioned
in http://contextures.com/xlDataVal03.html.
I face the problem that the data is alpha-numeric. How to modify the
solution so I am able to manage this kind of data?

I'm trying to create a validation list with data from access. The code
below already do it, but I have a big problem: in the field of access
database I can have duplicate data...
table: period

Every time I open Excel, the Automatic Calculation is set to manual. I go
into Tools -> Options, click the Calculation tab and set it to Automatic.
However, each time I reopen Excel it gets reset back to manual.
It was working fine and then one I day Excel crashed and it hasn't been ...

I have a workbook with 14 sheets related to students.
Sheet "personal" has personal information like address, date of birth...
Sheet "marks" has the different marks for that student.
The names of the students are copied from sheet "personal" (range A14:D58)