I am creating a spreadsheet for other people to use in which they fill in an
overview page which then feeds into 5 other sheets.
Which sheet the data feeds into is specified by a single column but all the
data around 60 columns needs to also be copied across to the the other

I am auto-updating a daily productivity sheet for employees, and I
need to know how to do the following:
=IF($B$1<1,"",IF($B$1=1,VLOOKUP($A4,$A$3:$B$68,2,FALSE),????????))
I need to know what I can put in the ???????????????? part for the

Hi.. I was wondering if someone could help me.  In my department,
about 5 people use and access a shared workbook that contains macros.
When the file is not shared, it operates perfectly fine.  However,
once shared, the file can take approximately 2 minutes to open.  While

I have a list of numbers in "Sheet 1" that I need to find in one or more
different worksheets (ie: "Sheet 2" & "Sheet 3").  The number may or may not
be found in the other worksheets.  There also could be multiple rows that
contain the number being found.

I am just beginning to learn how to use forms.  I was able to get one
form to open and close fine, then I added a 2nd form.  I admit I am
working by Rote, as I do not yet fully understand what I am coding.
Here is the code I use to open the 1st user form (I left out some

Can somebody help me with this code? What I need is the code to work
if the match is on the row below the first one. So I have the
following data:
         Column D        Column E            ColumnF

Hello,
I need a way to track product usage by months in MS Excel 2003. I need to
enter the start date of a period, which could be in the middle of a month,
and the end date of the period, which could be any time about 190 days later.

How to reference a macro defined in another workbook?
Clara

I am creating a menu with code that works in 03 to create a menu, and when I
call the routine, in Excel 07, the menu goes into the Add-Ins tab of the
ribbon.  If I Hide the ribbon with a different routine, the code does not
make this section visible.  Here is a section of the ...

I have a single excel sheet that I have to use to create multiple
reports by hiding specific columns (I have to use a single sheet, I
cannot create multiple sheets and just link them together).
Some of the reports need different headings such the report title and

I'm trying to port working Word VBA code into an Excel VBA module.
Because I don't know which version of Word my users have, I'm writing
it as late-binding code (everything Word is Dim'd as Object).  I think
'most everything is going okay so far (we'll find out when I smoke

Is it possible to select an existing chart object using VBA? The chart
should be selected as if I would have clicked on it manually (thick
border around it). In Excel 2007.
Thanks

If a chart is selected in Excel 2007, using
ActiveSheet.PageSetup.Orientation doesn't seem to return the orientation
of the active sheet, but the orientation of the selected chart object
(whatever the meaning of this value is...?).

I put an ActiveX control on a sheet by accident, and I deleted it and
I still get an error every time the worksheet is opened about enabling
ActiveX.
Is there a way to remove all traces of an ActiveX object so the error

I have a sheet containing a matrix of Cross references. Using the case
statement, I would like to be able to loop through each cell in the range,
double click to go to the sheet containing the data, select the row, then
paste into a report sheet.  Guess what -I can't get it to ...