Column Reference to External Source As a Variable
Can anyone help me convert the column referenced in the formula below into a variable that the user can define?
More specifically, I have several columns that I need to read from an external workbook (Short_Billy.xls). Each column to the right of column C represents an additional day out in a 14 day projection from today (whose data is held in column C).
In cell I5 of my active workbook (Inventory.xls), I would like the user to be able to enter a value representing the number of days out they would like to see the projection for (0=today=Column C, 1=Tomorrow=Column D, etc.). In cell I6, I...recipient update service #5
When itry and create abother recipient update service on my 2003 sp1 server
i cant, i get an error ("invalid argument") also when i go to the properties
of my existing recipient update services for enterprise and domain I do not
see the properties, all is see is the general, object and security tabs. I
have two exchange 2003 servers that srte in the same admin and routing group,
I get the same issue on the second server.
Would running domain prep or forest prep help resolve this issue?
Why do you need to create a new Recipient Update Service?
I would like to do a combo chart. Any ideas?
Plot all the data in a chart using the chart type you want to use for
most of the series. Select one series you want to change, choose Chart
Type from the Chart menu, and pick the chart type you want for this
series. Repeat for any other series you want to change.
Excel offers some built in combo types, but it's easy to make your own,
and you can be much more flexible this way.
Jon Peltier, Microsoft Excel MVP
> I wou...Cannot Update Prices Online
I can no longer updated prices online. I use 2003 stnd.
When on Portfolio page, if i click on Update Prices on the
left, the only option I now have is Update Prices
Manually. There is no longer any option for Update Prices
Also, on the home page if I do click the Update Online
Quotes link, all it does is refresh my related investment
charts on the home page.
This has worked with no problem as long as I can
remember. I cannot think of any changes or updates I have
made to the software or options...
Standard Edition? In use for a year now? Read the License Agreement
(Hel...upgrading the OS on Exch2003 box
I have successfully upgraded Exch2000 to 2003.
The OS is still Windows 2000 Server.
Now I'm ready to upgrade that box to Windows Server 2003.
Is there anything special I should note before upgrading, or is there
a specific document which addresses any known method or problems ?
"chrism" <chris@no_spam> wrote:
>I have successfully upgraded Exch2000 to 2003.
>The OS is still Windows 2000 Server.
>Now I'm ready to upgrade that box to Windows Server 2003.
>Is there anything special I should note before upgrading, or is there
>a...Won't configure updates...
I am able to install updates, and actually get a "pending" message beside the
updates in the Update Manager. But when I restart my computer, I get a 0%
installed message next to the 3-3 updates etc. then a message that the
updates weren't configured correctly.
I'm about ready to punt, any help is appreciated.
Free unlimited installation and compatibility support is available for
Windows Vista, but only for Service Pack 2 (SP2). This support, originally
scheduled to end 26 November 2009, has been extended until 26 February 2010.
A...Update one table from another
I am trying to update one table that has one record for each employee(table
1) with available vacation time. The other table records every time off
request(table 2) and how much time they want off. I have the update query
and it works fine. The problem is that everytime it is ran every requested
time off amount(from table2) is subtracted from the available time(table1)
again and again. I want the records for requested time(table2) to update the
employee available time off(table1) only once, but keep the records on the
table as that is the basis for a report.
----=...Update MSN Services with Money 2007
How can I update the Portfoglio and Accounts on MSN with MS Money 2007
Deluxe version ???
Thank you. Bye.
In microsoft.public.money, Paolo B. wrote:
>How can I update the Portfoglio and Accounts on MSN with MS Money 2007
>Deluxe version ???
Transactions that you enter yourself into Microsoft Money 2007 would
not be forwarded out to MSN Money. This keeps that info on your own
For institutions with their own OFX servers, you would have to set
up those accounts to download into MSN Money also.
Accounts where the data comes in via "third party" ...Can't install windows updates on SBS 2003
I have a SBS 2003 server that has not been updated in a couple years. It has
SP2 installed but when I run Microsoft Update it needs to download and
install 96 updates. When I try to get them installed it comes back with an
error saying not enough disk space. I have tried to just install 1 update at
a time and get the same error. The C:\ drive has over 14GB of free space and
the other drives have plenty of space as well. I restarted the server and
also ran Disk Cleanup, as the error message reccomends, but am still having
the same problem. Anyone run across this problem befo...How to write a new entry in a combo box to its underlying table
Dear Access 2007 VBA Gurus,
I have a assets database (rather uncreatively named "Assets"). I use a form
(named "Asset Acquisition Input Form New") to enter new assets. The
"Manufacturer" field (combo box name "Manufacturers_ID) on this form is a
lookup to a Manufacturers table. What I want to happen is when I enter an
item that is not in the lookup list, I want a message box to prompt me to add
the new entry to the underlying table, or to cancel and select an item from
the list. I have no trouble with the MsgBox command itself. What I don&...Can I abbreviate one value in a data series?
I've got a chart where one value (8,300) greatly exceeds all the others. Is
there a way to abbreviate this value so the other data points show better in
One way is to break the Y axis, have a look at these examples of how to
> I've got a chart where one value (8,300) greatly exceeds all the others. Is
> there a way to abbreviate this value so the other da...Return values that sum to a known value
I have a list of data and would like to know if there is a formula that would
return any items from that list that sum to a known value.
Have a look at this thread for something similar:
> I have a list of data and would like to know if there is a formula that would
> return any items from that list that sum to a known value.
...After 12.2.4 update, cannot open some Word docs with Open passwords
Operating System: Mac OS X 10.5 (Leopard)
After installing the 12.2.4 Office update, I am unable to open some Word files that I had password-protected with an Open File password. How can I open? Thanks
Basically, "you can't".
Sorry, the other passwords are crackable, but "Password to Open" is
effectively the encryption key. The entire file is encrypted, and unless
you have the correct password, you can't get it open.
However, are you sure you are not attempting to open files that were
password-=protected on the PC? ...Default picklist values not appearing on convert from lead to acco
Converting a lead to an account. I have several picklist fields (on the
account) which should bring up a default value. When I create a new account
from scratch they all appear. When I convert a lead to an account none of the
default values are there. There are no offending mappings or scripts that
would explain this. Has anyone else seen this or can offer any guidance.
Default values are not set on enties which are converted or created trough
the webservice. The only way to have a default value set for any path is to
use the PreCreate Callout.
Patrick Verbeeten (MC...E-mail box sizes. Echange System Manger.
Now and then I need to find out the size of the various e-mail boxes in
Exchange2000. The problem is that the size indicated in the Exchange System
Manager do not reflect the same size when you look into Outlook.
Is the a way to figure out the correct e-mail size?
If not. Is this better in Exchange2003?
Thank you in advance.
I'd consider the Exchange value to be the most important given this is what
will be used for mailbox quotas, etc.
"Dag N" <email@example.com> wrote in message
> Now and then ...Windows Update Office 2007 Converter confusion
On my desktop I have Office 2003 (laptop has Office 2007). I recently
received an attachment in .docx format (2007). I downloaded the converter to
my desktop and opened the document. Now on my desktop (which has Office 2003)
I receive update notices for Office 2007. Should I ignore these? Hide them?
Install them? Will I still be notified re updates needed for Office 2003?
Thank you for whatever insight you can provide. If you can give me some of
the background explanation as to why this is happening (I presume related to
the 2007 converter viewer install), I can understand bett...Selecting cell value for a sum, based on a condition
Trying to come up with a formula or method that will enable me to sum values
based on a condition. For example, I have three columns which contain a
condition and two amounts. If the condition is of the 'each' variety, one value
will be used in the sum. If the condition is of the "square foot" variety,
another value will be used. Here is a small diagram that may help visualize
A B C D
1 Measure Unit Cost S.F. Cost Summed Total
2 Each 3.00 .30
3 S.F....How to return the primary key from a combo box
I have a table containing two columns
Column 1: Primary key
Column 2: Name.
I want to create an unbound combo box that shows the name but returns the PK.
I have these properties set:
Control source: <is empty>
Row source type: table/query
Bound column: 1
Row source: <I have a select that returns the desired records>
In cboClient_AfterUpdate() I look at debug.print cboClient.Value and I see
the name. I need the PK so I can construct the query for the next combo box.
How do I get the PK
Thanks for the help
Message posted via http://www.accessmons...Simple Yes/No drop down box
Hi, I am looking to create a simple drop down box which has yes or no as the
options. For the life of me i can't remember how to do it.
Select the cell and then click on Data | Data Validation. In the
dialogue box for Allow click on List, and then in Source you can type
"Yes,No" (without the quotes) and ensure that In-cell drop-down is
checked. Click OK and then you have it.
Hope this helps.
On Apr 21, 9:41=A0am, Debi <D...@discussions.microsoft.com> wrote:
> Hi, I am looking to create a simple drop down box which has yes or no as =
...creating nested formulas from drop down box
Hi, I have cell A1 with a drop down box containing 26 available choices. B1
has the dollar amount matching to the choice in A1 using vlookup. E1 totals
several cells including B1 together. I want F1 to look at A1 and either
enter the number from E1 or NA. Here's billing example:
A1=January , B1=$5 ,C1=$10, D1=$1, E1=$16 (total of b-d1)
F1 is the column for January
G1 is the column for February
H1 is the column for March, etc
If A1 = Jan, then F1 should be $16
If A1 = Feb, then F1 should be NA or $0
This is the formula that has been working so far:
=IF((G2="...How do I make X-values of a chart dependent on values in cells?
I have a chart which can go from x-value 0 to x-value 200. However
I'd like to be able to input min X-value into a cell, and a max X-valu
into a cell, and the x-value in the chart changes to reflect that.
Is it possible to do that?
Thanks for any replies.
Message posted from http://www.ExcelForum.com
There is no automatic way to do this but take a look a Tushar's
AutoChart Manager for a possible solution.
Kashgarinn < wrote:
> I have a chart which can go from x-value 0 to x-value 200...set value of a group of activex control points
Have a spreadsheet that has some 20+ activex control points (option buttons).
Is there a way to group all these controls together & set their initial
values the same? Trying to setup a "reset" type of operation that would clear
all control points. I can do them individually via properties, but it's too
...anchor picture to text box
(Publisher 2003) I have a newsletter with a Kudos box. In the corners of
the box I have a happy face. I'd like the happy faces to be anchored to
their corners so when I enlarge or shorten the box, the faces move along with
the text box.
Why not create a rectangle, insert the happy faces, group. The problem as I see
it would be if you resize, the happy faces could be distorted if you widen or
shrink the group. You would always have to re-size proportionally.
"Helen" <Helen@discussions.microsoft.com> wrote in message
news:193...Storing distinct values in an array
in the speadsheet, i have a column containing a series of numbers
maybe of them repeated multiple times...
i would like to store all distinct values in an array
any ideas on how i could do that ...
eg , if these were the numbers going down column then 1 3 5 7 5 3 5 7
5 4 3 4 5 7 8 5 3 .. store 1,3,5,7,9,4,8 in an array, in no specifi
shimeel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1583
View this thread: http://www.excelforum.com/showt...How to determine whether update rollup is installed
I've just installed the update rollup on test machines both for client
and server. However there's no obvious change - even the build version
numbers shown on the web interface remain the same. Is this to be
expected? How can I tell that the update is installed successfully?
Not sure why they didn't update the version number. On the server, go to
add/remove programs and check the 'show updates' checkbox at the top. then,
under the Microsoft CRM Server, you should see 'Update Rollup 1...'