I have the tables all set and their labels are in place and I have the box ready with the reference to the list of years - which is the common value in the...

I would like to build an audit trail into a spreadsheet so that anyone who opens the file is is logged in a worksheet with user name and time stamp. What's...

Basically, I am trying to rank a range of numbers, but when there are two numbers of the same value, I don't want the number that is returned to be their...

On Mar 29, 12:45*pm, Eric wrote: Do you mean the Enable/Disable macros dialog that appears when the workbook opens? If so,...

Please help in this formula {=SUM(('A1 1-3'!$C$3:$C$19268=B$11)*('A1 1-3'!$E$3:$E$19268=$A9)*('A1 1-3'!$G$3:$G$19268=$H3)*'A1 1-3'!$S$3:$Y$19268)} the...

We are constantly having someone open up an excel workbook within our network and not closing it before they go home. This does not allow us to continue...

Seek a formula that once monthly automatically recalculates an auto lease unpaid balance upon detecting a month date change.

Please Help. I have two cells, A1, B1. In B1 I want the current date if A1 is populated. If A1 is not populated I would like the message " Input" in...

I have the following code which deletes all rows older then 365 days: Sub Del_Oldies() LR = Cells(Rows.Count, 1).End(xlUp).Row For R = LR To 1 Step...

Does anyone have any suggestions on how to create a pull down lists? There is a list of values from cell A1 to A10, I would like to create a pull down list to...

Hi, When I refer to a cell in another spreadsheet, the cell reference always automatically defaults to absolute (e.g. $A$4). In most cases I don't want the...

I am saving a spreadsheet with a new name. When I run the macro in the new spreadsheet, it automatically opens up the old spreadsheet as well as doing the...

I've got someone trying to work with a 400MB Excel spreadsheet using Office 2007. Excel keeps crashing when trying to modify and then save the file. ...

I need to lookup a number from one workbook to another, however, I want to look up the value in ALL 800 tabs, not just the first tab. Is there a formula...

Hello, I am working with a 3rd part template in excel that has fill in fields. The issue I am having is that, the file works fine on my computer, but on other...

I have an Excel 2003 database that I used to do "Mail Merge" in Word or Publicher for all types of reports, labels, lists, certificates, etc. Now I'm using...

I need a formula to fill in names in sheet 3 into the time slots that correspond with thier assignments in sheets 1 and 2. For instance, the formula in cell...

Hello All! Can someone please point me to a description of Pivot Tables and their use? Perhaps, a not too expensive text book would be appropriate. --...

Hi, I'm trying to create an IF AND Today() function. The difficulties I'm having with this is that when I enter the TODAY() portion of the function the...

1) just creating a simple spreadsheet with names in columns and rows. entered all that in , but need to choose gridlines . cant find where to activate...