Search results for query: *

How would I do this? If A2 is >= 1/1/2003 and <12/31/2003, put "2003" in T2 If A2 is >= 1/1/2004 and <=12/31/2004, put "2004" in T2 If A2 is >= 1/1/2005 and <=5/31/2005, put "1H2005" in T2 If A2 is >= 6/1/2005 and <=12/31/2005, put "2H2005" in T2 If A2 is >12/31/2005, put "2006 or over" Thanks...

I have a spreadsheet that I want to hide. I go to Properties and click Hidden and then Apply. What happens is that once I exit out of Excel, the hidden files appear again. Am I missing something? Thanks in advance.

Thanks, this worked like a charm!

I have a main form and a sub form. In the main form, I have a button that when clicked, prompts for the ID number and then emails that record from the subform. I would like to include the ID number in the email subject. However, because the ID resides on the subform, it is not recognized...

Another suggestion could be that you do a conditional format and make the field white when value = 0.

I have a spreadsheet with a hyperlink bookmark to a separate worksbook. There are several worksheets in the separate workbook that I am navigating back and forth to, so when the user navigates back and forth, it thinks it wants to open it again. Is there a way for Excel to know that the...

Now I can't get this formula to work. Two worksheets: FcstAdj and 0003 If FcstAdj!F2:F49 ="30 day forecast" and If FcstAdj!C2:C50='0003'!B4 Then add up everything in FcstAdj!D2:D50 =SUMPRODUCT(FcstAdj!$F$2:$F$49="30 day forecast")*(FcstAdj!$C$2:$C$50='0003'!B5)*(FcstAdj!$D$2:$D$50) I'm...

I get the following error message when trying to save a template (kind of, anyway, my version is in Swedish): 'Excel cannot complete task with available resources. Choose a smaller amount af odata or close other applications' (OK button only) This is followed by an immediate new msgbox...

Thank you - this worked like a charm!

Thanks - why do you have two )) in some places?

I have a spreadsheet that I would like to add up a column if the below criteria is met: Sheet1 If Column A = whenever it equals "red" If Column B whenever it is between "03/01/2005" and "03/31/05" If Column C = whenever it equals "0712" Sheet2 Put that value in Sheet2, Column D. So if on...

Either way would be fine -- I tried both and neither worked.

I want to create a macro that will group columns F & G and columns J & K - all at the same time. This worksheet has the "Forecast" and "Actual" numbers. So when the macro is run, it will only show columns A-E and columns H-I, and any columns pass column K (these are the "Forecast" numbers)...

I have a report that I have a field [Total/Project Balance]. I also have lines for CustName that each have a Total/Project Balance. There may be many lines for each CustName, each with their corresponding Total/Project Balance. I want to total up all of the [Total/Project Balance] for the...

I have an Excel spreadsheet that is updated every week. I would like to import this spreadsheet every week into an Access database. I know how to do this, but now I need to take this further. When I import the spreadsheet every week, I am using the CustName field as the primary key. The...

Thanks for the response. I pasted this code in the AfterUpdate of NoTransition. However, I am still able to enter a date in DateTransitioned. This form does refer to a table with over 1,000 records. You mentioned OnCurrent event. What do I need to do there to make this work? Thanks.

I have a form that has two fields. [DateTransitioned] (mm/dd/yy format) [NoTransition] (yes/no format) If the user checks the [NoTransition] box, I want to grey out the [DateTransitioned] field and so that the user cannot put a date in there. The error message that should appear is "Since...

I have a report that is based off of a query. In the query, I prompt for employee's name [EEName]. The EEName may be in several places, so I added a field that combines all of the several places in one field. Then I put in a prompt that asks for the employee's last name. EENameAll: [Field1]...

Thank you! This worked perfectly!

How do you open up to the first worksheet (tab named "MainMenu") each time you open up your Excel file. I want to send an Excel file to a few people and I want Excel to automatically open to MainMenu each time they go into the file. Let's say they open up the Excel file which is an attachment...