Using Function to call Woorbook Sheet
I would like to use WEEKDAY() to call a particular Sheet in a Wookbook. The
Sheets are called Sunday - Saturday and I have an IF statement that needs to
check for particular information on that sheet depending on what day it is.
Have it currently functioning but it is taking up way to much space. I am
unable to update my code with other functions that I need it to calculate
until I can figure this part out.
=IF(OR(AND((TEXT(TODAY(),"dddd")="Monday"),(HLOOKUP(MOD(NOW(),1),Monday!$B$1:$BA$40,2))>0),AND((TEXT(TODAY(),"dddd")="Tuesday"),(HLOOKU...Time reg: Creating an Outlook Calendar appointment from the order
It would be a great feature when it comes to time registration, if it was
possible from the Order View in the CRM Outlook client to draw an order
directly into the Outlook Calendar, thereby using it for time registration.
In that case, it should be possible to select which data fields would be
transferred to the Outlook Calendar Appointment, enabling all sorts of time
I'm quite certain many companies would benefit from such a feature. I know
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most...Multiple instances of a property sheet
I have two windows as part of my application, say W1 and W2. They are
both derived from CFrameWnd. I have a class derived from
CPropertySheet that is instantiated/displayed by both windows. When I
create an instance of my property sheet (let's call it P1) from W1
(the property sheet is modal to W1) and then create another instance
of my property sheet (P2) from W2 (modal to W2), I cannot close P1 by
clicking OK or Cancel. Clicking OK or Cancel is completely
ineffective; the dialog remains open. Then, if I close P2 by clicking
OK or Cancel, both property sheets are closed.
I augment CProp...Upgrading to 9.0 on Windows Server 2003 64bit Edition
We are upgrading from 7.0 to 9.0. We have new SQL Servers on which we
will perform the upgrade and move into production once complete
replacing our existing servers. These SQL Servers are running Windows
Server 2003 Enterprise x64 Edition. When attempting to install either
GP v7.0 or v7.5 the error message "The image file ...\CDSetup.exe is
valid, but is for a machine type other than the current machine." is
presented and the installation script will not initialize. Is it
possible to install GP 7.0 or 7.5 on the 64bit version of Windows
Server 2003 or must we install the 32 bit v...Selecting rows from various sheets #4
shav's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1198
View this thread: http://www.excelforum.com/showthread.php?threadid=26665
...Formatting four pages onto one 12x18 sheet
I'm trying to figure out how to format a 12 x 18 sheet with four individual
5.5 x 8.5 pages on it. Any ideas? The closest I can get is under page
setup...selecting "postcards" and that will give me three pages per sheet,
but I need four.
Any ideas or thoughts are greatly appreciated.
If your printer can be custom setup to 12 x 18 then you can divide it into four
parts. Are you sure you aren't trying to setup a 11 x 17 landscaped sheet? In
any event, setup your printer first.
File, Page Setup, Advanced on the right, type 18 width, 12 height or 17 width,
11 ...Keep Added Custom Fields on New Projects
We are importing information from our bidding software. The export is
created in XML file. We know the custom fields that are created. How do I
make MS Project use the same "look" everytime? I want it to remember the
custom fields I created and use that as my default blank project. I don't
care about the tasks because those could be different every time. I just
want to be able to create each project with the same columns every time.
Create or update a view/table with the custom fields and layout you are
wanting. Then change the Tools-->Options--View tab to ...Do I need DSClient to run Exchange 5.5 on an NT4.0 box in Windows 2003 Native Mode ADS?
I am in the process of migrating my WinNT4.0 domain and Exchange 5.5
Org to Windows 2003 ADS/Exchange 2003. I know best practice is to
change the domain to Native mode, but how does this affect my NT4.0
server running 5.5? Do I need to simply load the DSClient onto the
I should also note that we did an inplace upgrade from NT 4.0. This is
a single domain environment.
As long as you no longer have NT 4.0 BDCs you should be able to move to
native mode. Your NT 4.0 server running E55 will not be affected (unless of
course it is also a BDC).
It is a good idea to...Creating a Relationship Between Order Product (salesorderdetail) and Service Activity (serviceappointment)
We are using CRM 4.0 to run a consulting business. Its working pretty
well but we want to simply the way we are doing some things. What we
want to do is create an Order (salesorder) with multiple Order
Products (salesorderdetal). So good so far.
Next I want to be able associate each Order Product (salesorderdetail)
with a Service Activity (serviceappointment), this representing that
this billable line item in the order is actually going to be fulfilled
as a consuting engagement.
The problem is, I can't seem to be able to create an association
between the Order Product (salesor...Excel sheet protected
I have a space in my sheet1 that is blocked but I need work in this space
with a VBA macro.
How can I work in this blocked space by keeping (after macro) the cells
You could have your macro unprotect the worksheet, do its work and then
reprotect the worksheet.
'do your work
> Hello all
> I have a space in my sheet1 that is blocked but I need work in this space
> with a VBA macro.
> How can I wo...Exchange 5.5 in Windows 2000 Domain
HI I am looking for any advise I can get on this subject, or any references
you may have.
Basically I have an NT4 PDC that currently has Exchange 5.5 installed on it.
I have a windows 2000 Database server that is just a member server of hte
My NT4 machine is running out of space, so I am getting a new server for
exchange. I will install Windows 2000 on this server and then follow the Ed
Crowley Server Move method, to move my exchange server over to this new
I am comfortable with this. I have just now installed an NT4 BDC into the
domain (it is only a very old machine so it ...Archiving of Windows Live Mail
Can someone please point me to a procedure that will explain how to off load
a bunch of emails that I want to keep but do not want in the active WLM
folders. Seems like in the Outlook Express days there was a way but I have
long since forgot what I did. Help appreciated.
You could create a folder(s) on the Desktop and just drag messages into
Imperial Beach, CA
"Ken" <email@example.com> wrote in message
> Can someone please poin...Project Accounting workstation install
After installing and registering PA on the server, do I have to run through
the PA install on all of the workstations as well?
If so, is there a way to mass install to all of them? or do I have to do it
workstation by workstation?
In GP10, PA objects initialization is invoked when you launch GP utilities
after adding PA feature, this is one-off process for each company databases.
However, you have to perform the GP-PA client installation process (adding
PA feature) on each machine with GP 10, this will convert the chunk file
(.CNK) to resource dictionaries associated wi...Export News from Outlook express and import into windows mail
I only used outlook express for newsgroup so I need to backup and transfer
all the messages that I flagged with the glasses icon. I just installed
windows mail and it only downloaded the first 1000 messages. I can't see all
of my messages because some of them they are old ... maybe 2002 but i need
them all in the same place.
How can I transfer these messages and the replies to windows mail?
Outlook Express as well as other newsreaders only mirror what is on a news
server and newsgroups neither import nor export. You can only export the
account setting, but not groups or...Order of X-axis
Col A has dates, in order but with most recent toward top. Col D has data
to be graphed. What I want is for the resulting graph to have the most
recent date on the RIGHT side of the graph (on the X-Axis) and the earliest
dates on the LEFT. The order on the spreadsheet really can't be changed to
TIA for any help you can give.
Double click the X axis and on the scale tab of the format dialog check,
Dates in Reverse order
To keep the Y axis labels on the left also check
Value (Y) axis crosses at maximum value
Andy Pope,...Office 2004 Project Gallery
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
In the main screen of the Office 2004 Project Gallery, there are icons for
things like �Mail Message� and �Calendar Event�. How can I add, for example,
�Address Book Entry� or �Task� to the Project Gallery?
<HTML...Why do sheet tabs keep disappearing? Box in Tools is checked.
When I open a new or existing Excel file, the sheet tabs at the bottom may or
may not show up. I have repeatedly gone to Tools, Options, View and made
sure the sheet tabs box is checked, but still no tabs. How do I get them
back? I can't get from one page of a workbook to another. This is in
In the Sheets in new workbook box, check and see how many sheets are
set to appear when opening a new workbook.
keithl816's Profile: http://w...Compare Sheets #2
I'm going insane
I'm trying to compare two sheets using Walkenbach's approach but for
some reason when I use it...certain values don't show differences.
Sheet 1 (Range Name is Grid) has 18000 on Cell A1
Sheet 2 (Range Name is OldGrid) has 18000 on Cell A2
So if I change Cell A1 on Sheet 1 to 1 it should show me change but
no...it just does nothing. However if I type 133...it shows change.
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
Selection.FormatConditions(1).Interior.ColorIndex = 40
Help really appreciate...Windows XP
I have a windows xp sp3 machine where there free space goes down to a fixed
amount after a reset. Let me explain:
I boot the machine (a 40GB HD divided in a 36GB and a 4GB partition), The
4GB partition shows only 600MB free, I run CHKDSK /F D: and it fixes the free
space to 2 GB, I reset and it goes back to 600. The same situation is for the
36GB partition where it shows 4GB free but if I boot to the Recovery Console
and run chkdsk c: /p it fixes the free space to 18GB but as soon as I reset
the free space goes back to 4GB, so the same thing happens if chkdsk runs at
boot. Win...How to reduce thickness/width of window borders two "normal" 2 pixels?
On a certain WinXP all borders of all windows are very, very thick/width.
Have a look at the following snapshot:
What is the reason resp. how can I reduce it to the "normal" size of (approx. 2 pixels) ?
Camille Petersen wrote:
> On a certain WinXP all borders of all windows are very, very thick/width.
> Have a look at the following snapshot:
> What is the reason resp. how can I reduce it to the &...How do I restore the cell content window on my toobar?
tools options view ........formula bar
Greetings from New Zealand
"hutchc" <firstname.lastname@example.org> wrote in message
From the View menu, choose Formula Bar
Excel FAQ, Tips & Book List
...Formula involving different sheets
Using Excel 2003.
In sheet 1, cell A1: =200/1200
In sheet 2, cell B2: =300/1200
In sheet 3 in a cell, I want to do =200/1200 + 300/1200 by cell reference.
How do I do so?
Your formula would be:
The best way to create these formulae is to get Excel to do it.
1: Type = into your cell
2: Navigate to your sheet1!a1 cell. You will notice in the formula bar that
Excel is adding its address to your formula
3: Type +
4: Navigate to your sheet2!b2 cell.
5: Hit enter
Once you learn this, you will never type a cell address again.
Regar...Launch folder windows in separate processe
The setting as in subject selected under Control Panel -> Folder Options
More than one windows explorer open. Each of them opened in other
folder. One of them opened for search function.
However, if investigating with Task Manager all windows explorer windows
lead to the same explorer process (task right click -> Go to process).
The list "Processes" of task manager presents only one explorer window.
So the setting as mentioned above not really functional.
What's the reason?
> The setting as in subject selected under Control Panel ...Open Excel with a particular sheet to be displayed first
I have an Excel file which has 20 sheets. Is it possible
for me to open this Excel file and display Sheet10 first,
rather than the focus in whatever sheet when last saved.
Your helps are much appreciated.
Thanks & Regards
You need something like this in the ThisWorkbook module
Private Sub Workbook_Open()
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
availab...how do I set up spread sheet for demographical data to get graph.
I need to set up a spread sheet to be able to get age, sex,service usage
numbers, site utilisation, presenting issue e.g., drug and alcohol, region,
percentage of use base on population e.g, 80 staff
Do you want to show these results graphically, or in the form of some sort
of output table?
How are you intending to get the data or enter the data into this sheet?
How many worksheets or tables will you need?
What is the final display options: Examples, Reports, Charts, Pivot =
And lastly who are the end users, and how do they...