Just a quick query...
Is it possible to use VLOOKUP across worksbooks. I'm creating a Gantt
chart in a new workbook, but need to reference dates in an existing
spreadsheet.

I thought it should be easy.  I'm writing a macro.  The first part leads the
Active Cell to a location depending on the value of various (declared)
variables.  I then want to copy the value in this cell to another cell on
the same Worksheet.      The line in the title doesn't ...

Excel ?undefined:
--
Bart Vw

I am new to this group.
I am having a large data set which has 1- 6 columns and each column
has 1440 rows. Now I need to average valuesin 1-15 rows and  then 16
-30 and so on. Then put the data in a new column. Since I have a large

Is it possible to HIDE your macros and VBA work from the user? If not, is it
possible to PROTECT them from change. Tried Protect Workbook but that didn't
work.
ken

I am looking for a means by which to select a range of cells
dynamically, by prompting excel to look for the last non-zero cell in a
column of data.  My goal is to apply a name to a range of cells, but I
need to be sure that I capture all of the data in a column, so I am

THIS IS MY PROBLEM:
i got a row with alpha_num entries(e.g RN1, P2, EN4)
i wan to count the number of entries that  has the number 1 behind the
first two

I am attempting to analyze financial data that is only available in a
poorly organized text file.  Currently we have developed a macro that
imports the file to excel, then breaks out the information by
individual componants on separate sheets. I have two actions to perform

when i save my excel file i get a saved  copy of the file, not the file
itself   so     my file name of a file i save 7 times can have  7 'a copy' in
it
eg   c./my doc/a copy/a copy/ a copy..............a copy/xx.xls

hi - i'm a teacher and am after some help changing the structure of a large
table.
i am given every few weeks an excel table with the structure
Columns:  Admin    RedMon    RedTue    RedWed    RedThu    RedFri    BluMon

Hello All.  I joined the group this morning.
I have a spreadsheet where I am calculating Runtimes.
Job Name        Date        Start Time End Time       Run Time

I want the text of cell n1 to be b1 + a string, or empty if b1 is
empty.
I currently have
=IF(B1<>"",B1,"")

I am using the book "Microsoft Excel Data Analysis and Business Modeling"
ISBN 0-7356-1901-8 This is published by Microsoft. The CD rom is missing a
lot of the .xls files that are discussed in the book. I looked on the book's
corrections page that Microsoft has and the files are ...

I am using Excel 97 and opening a CSV file that includes a column that is
always text and always enclosed in double quotes.  Somethimes this text is
text that could be interpreted as a date ("10/1" for example).  When I open
the file, Excel always changes these values to date ...

I copied Worksheet 1 to worksheet2 and lost my date formats.  The date
is now showing as the General format (36821)  instead of mm/dd/yy.  I
tried to change the the cell in the Format option, but that did not
work for me.