Can anyone help with this.
I have give a workbook a variable name . When I try to call it in the
Vlookup formula it does not recognise the file name.
Here is the sequence

I have 8 columns that MAY contain NOTHING or may contain text chosen
from a lookup name from a data validation pick list. Lic3 won't
contain a value UNLESS Lic1 AND Lic2 are populated.
I have 8 columns range named Lic1, Lic2, etc to hold a chosen license

I know that a row will always be inserted above the active row, but it is
visually confusing to me in which direction new columns are inserted. Are
they inserted to the right or left of the active column?

Is there a way to change the date format in footers and headers.?.these two
items do not seem to pick up the formatting specified for the individual
cells.
David H.

can u plz let me know wat is g look up

I have a workbook, that has multiple worksheets.
each worksheet is a form, with identical layout, but different data.
Each page is formatted to print A4 fit to page.
Is it possible to convert the workbook to a word document, with each

I want to lookup a value in a sheet and when found give me the value
of the cell next to it. Vlookup will not work because the value looked
for is not necessarily in the same column. If I use
=VLOOKUP("beef",B:F,2,FALSE) it works great if the word beef is in

I have a worksheet (sheet2) used as a report. It should be printed on ONE
page A4 size.
Some rows between 7 and 25 have the first cell empty (no value is shown).
The values in the range A7:A25 are copied from another sheet (sheet1).

I have a column of dates, formatted as date dd/mm/yyyy. I would like to have
a formula in one cell that will evaluate the entire range to check if all
the dates are within a given year. If A1 is 01/01/2008, I can put
=year(a1)=2008 in B1 and return a true or false, but I can't seem ...

I am using Excel 2002 to import data from another program into a
spreadsheet, using the Text To columns feature. I have a macro that
works fine to go to the drive [K:/], and find the file, which is named
"mydata". is it possible to have a box appear that would enable a user

I am trying to change the way my Excel behaives (or mis-behaives) when
I drag a range filled with numbers.  Currently, it repeats the number
sequence, but I want it to continue with the next number a keep going
up.

Hello, I am new to excel currently working with Moss sharepoint
I have a "ticket" that needs to pull data from another excel workbook when
they need to update a budget and they send it in for approval using moss.
Is that possible?  I am new to this and looking for ways to make ...

I have a range A1:S1 with a series of integers and a range A2:S2 with
another series of integers. How can I count all the instances where the
equivalent cell in the second range is equal to two less than that in the
first range.

I have created the following peace of code:
'Finds company within the peer group
   On Error Goto CompanyNotPartofPeerGroup
     Cells.Find(What:=ExcludedCompany, After:=Cells(1, 1),

How do I hide VBAProject(Global.xls) in project explorer. I just want
my normal project there.
Helge