Vlookup
Tue, 14 Oct 2008 10:46:14 -0700
I have a worksheet I am trying to have the user select the year for the pay
rates and after that I want them to use a Vlookup function.
IE-Year:2008
=VLOOKUP(C10,'Equipment & Labor Sheet'!A:W,3,FALSE)
I am making a bid form so that a year is first selected based on when the
work will be completed. Then th ...
|
Merging Files using Employe ID Number
Tue, 14 Oct 2008 10:22:01 -0700
I'm trying to reconcile billing that are in excel format. Both billings have
employee ID numbers. Is there a way I can merge the two files together and
get the desire results of who is not one what report?
--
Ms. Davis ...
|
Different colors for different sets duplicate cells
Tue, 14 Oct 2008 10:03:01 -0700
Okay...I think I can do this in Excel 2007 with color ranges for conditional
formatting but I'm using Excel 2003 and need help coloring some cells. What
I have, very simply, is a single row of numbers in which duplicates can
arise. I not only want to change the color of the duplicates (which I have
already ...
|
Macro or code to insert Shape (Say Smiley face) in XL?
Tue, 14 Oct 2008 09:38:06 -0700
Want to insert smiley face shape when long macro is complete. Apparently XL
2007 won't allow one to record this. Help appreciated, but I am a novice with
VBA nothing too complicated please. Thanks ...
|
current week, current month, current year
Tue, 14 Oct 2008 09:36:06 -0700
is it possible (either via vba or some function in excel) to indicate where a
particular date falls (e.g. within the current week, current month, and
current year)?
looking to create a report that identifies records as falling into current
week, current month (excluding those that fall within current week), ...
|
Userforms & worksheets
Tue, 14 Oct 2008 09:11:02 -0700
In a textbox on a userform I want to display the next available number from
the worksheet "CD" - column A.
Column A is sequentially numbered so essentially it would be LastRow + 1
I can get the date and time and usernames in other text boxes on the user
form (i.e. UserForm1.TextBox21.Value = UserName()) but I ...
|
CheckBox Help
Tue, 14 Oct 2008 15:33:43 GMT
I have an issue with CheckBoxes on a UserForm not doing what I want them to,
and I hope somebody can help me with it. The workbook includes over 100
vehicles, and each month we go through the process of uploading new values
for these vehicles into our â??system.â? The workbook consists of the previous
monthâ??s ...
|
|
|
sendmail recipient
Tue, 14 Oct 2008 08:14:10 -0700
does anyone know how to get the email function to email a recipient whos
address is in a cell (D21) ?
eg-- how do i get this to work:-
With Dest
.SaveAs TempFilePath & TempFileName & FileExtStr,
FileFormat:=FileFormatNum
On Error Resume Next
.SendMail Sheets("Options").Range("D21" ...
|
Creating a Macro that saves over a protected spreadsheet.
Tue, 14 Oct 2008 08:03:02 -0700
Is there a way to create a macro that can save over a protected file.
I used the macro record tool that comes with excel, to record the save as
function, however the document I am trying to save over is a protected file,
so I keep getting an error. Is there some code that can be added to my macro
listed ...
|
Adding Menus to the Ribbon
Tue, 14 Oct 2008 07:22:01 -0700
I have a 2007 Add-In workbook that has XML in it to add a Custon Menu Tab in
the Ribbon. How can I ensure that the tab is always placed last in the
Ribbon. For example, Home, Insert, Page Layout, ...., Developer, CUSTOM TAB
HERE.
Plus, I have noticed that if I save the workbook with a .xls extension the
...
|
