If i create a list in a cell and choose one value, is it possible to link
that value to another list in another column?
As i choose the value it would appear a list in another column with values
that relate only to that value that i chose. I can't do this with Vlookup

I have a Vlookup formula that is returning an #N/A for the value of the
formula.   Now the formula is written correctly but it only works when I
manually retype the value on the sheet I am trying to return the formula to.
In other words, if I have a value of 1234 on one sheet and ...

I download a file every day, I have a great macro that does a load of stuff
but have realised one shortcoming.
Every day the original worksheets name tab (business system generated)
includes the date, so it changes its name every day.

I've got 3 to 4 worksheets that i'd like to lind to a master that is
automatically updated each time i make a change to the support 3 - 4
worksheets.  All i'm trying to do is track the number of tests i receive on a
realtime basis.  I simply note the receipt on the supporting ...

How do I write the formula for "If A1 is true, then B1 is also true and the
result = A1+B1

If you have several sheets in a workbook, is there a way to copy your header
information to all pages without having to manually enter it in everyone one
of them?

Can you please help to get correct Vlookup function.
I have two huge Worksheet which has 45000 lines on each sheet. I want to
look up one value in both the sheet. If look value in not found in Sheet1
then go to Sheet2 & get the out from there.

I have a 24 month business plan, column headings are 1 through to 24.  The
first month of the plan can be any month of any year.  How do I, on a
separate sheet, show the calendar year (or part calendar year) results
without having to change the headings from 1 to 24 in the first ...

-- In a SUMIF statement how do you write the range and sum_range portions to
include two ranges, one range from sheet 1 and one range from sheet 2?
=SUMIF(Sheet1!B20:B39,"<>999",Sheet1!E20:E39) works fine for Sheet1, but I
can not get

Hi Excellers,
Can anyone suggest a solution for the following. I want to test C5 in D5 and
E5 using the MAX()  and MIN() functions. Dependent on the result Excel puts a
Zere in the opposite Cell. eg. in E5 will be a Zero because C5 is positive.

Hi, I am trying to use VLookup to find the last date that a value was entered
in.  I then use this date in a different location to calculate MTD Goals.  My
spreadsheet looks like the following:
Date     Total

I am running a macro to add rows or remove rows assigned to a form button.  
The problem is if the active cell is moved from the last blank row the marco
won't run.
Is it possible to have the macro alway return the cursor to the required

I have data in a worksheet that pulls to another, but I was wondering can I
set it up so that it only pulls data from the last month that I entered as it
goes on or do I have to make a new worksheet for each month of the data in
the workbook so that it only pulls the newest month ...

How do you auto-increase all values sitting in currency formatted cells of a
worksheet, by a percentage value.
Thanks, PaulF

I haven't found an answer on this question:
I would like to insert a photo by clicking in my worksheet. No problem.
My wish is, that the picture does not only appear there, but also two other
places in the BIG worksheet. Is it possible and how to do it???