I am creating a dashboard and I want a link on the main dashboard to go to a
cell on a specific sheet in a different workbook.  That's no problem...The
issue is that I want this link to show the value of the last used cell in a
column..Example:  I have a column for how many calls ...

I have to columns, each one start from 1 to 500. the data is mixed (No. and
letters)
What I want to do is matching between the same data with a color or sort
them by each other and the unmatched date should be at the end of both

how can i move my headings, when i scroll down: to move down and up with me?
can i make my columns move to the right ?
thank you

I would like the macro to copy a static range and paste it in spesific
rows depending on counter-formulas.
I have one counter in cell av1, at the time giving the result 331.
So for pasting in one cell, I change the recorded VBA-string:

How do I include the name of the user who last updated a file in the footer?
E.g. last updated by xx / ddmmmyyyy

How can I download Nasdaq stock symbols into Excel 97 on Win 98 platform
and then parse day to day symbol info because each day the total number of
symbols changes (i.e. 3,450 one day and next 3,530) to end up with a "common
list" of say, 3,000 Nasdaq symbols.  Then, please help ...

There was in earlier versions of excel set notation symbols in the symbol
table.  Are these symbols still available and where are they located?

With almost any programme opened on my computer, but also including Excel,
when I open the Help tag, it shows the subjects OK on te left, but the screen
on the right is the same as on Internet explorer when it cannot find an URL -
if I right click for properties, it shows t wrong ...

For some reason when the data in my spreadsheet is changed the result is not
updated to show this change in the source data. For instance if a formula is
set to add all the cells between range a1 and a5 and cell a3 is changed then
the result still shows the addition of the old ...

I want to convert a number into a different format. For example the number
1205050000 (without fullstops) will be converted to 12.05.05.0000 (with 3
fullstops).

i have a workbook containing multiple (about 10) worksheets with a reference
to sheet 1 for staff names, how can i sort the record on sheet 1 by the
reference (staff name) and ensure that the records in the other sheet have
moved as well... (i.e., if a staff member leaves, and i ...

I have a column of student ID numbers, a list of indefinite length,
like this:
A
40001

Hi i have a spreadsheet that has a column of different ages e.g
12.1
12.3
12.2

Is it possible to sum a column of values based on the values of
another column being the N largest / smallest?
An example might help undestand the concept...
Position    Animal    Colour    Volume    Value

If I have a list of numbers in a column  and I want to group like 1-3, 4-6,
7-10 how do I convert my list of single numbers into this format?