Auto change formula in cells when source is changed
Good day experts;
If specific cells have the same formula for example:
C1 = Product( A1;B1)
C16 = Product(A16;B16)
And so on ...
What formula should i write in C16, C17, ... so that:
when the formula in the source cell, C1, is changed the formulas in C16,
C17, ... would automatically change accordingly.
I tried "=C1" it does not work
Thanks in advance
> Good day experts;
> If specific cells have the same formula for example:
> C1 = Product( A1;B1)
> C16 = Product(A16;B16)
> C17= Product(A17;B17)
> And so on ...
...vacation tracking calendar on exel sheet for 2006
...setting up account for outlook?
Can anyone help me? Im new at this and would like to e-mail a friend whos over in iraq!
Talk to your ISP - they will give you all the information you need to set up
your account. We cannot.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Rasheem asked:
| Can anyone help me? Im new at this and would like to e-mail a friend
| whos over in iraq!
...Favorite Folders reverts to default list when computer shut-down
I have no problem adding, deleting or moving folders in the Favorite Folders pane. The problem is that they all disappear and revert to the default list everytime my computer is shut down. So I have to keep adding the folders back in
Is there a way to keep the shortcut folders in the Favorite Folders pane?
...Changing a text field to a date field
Hi I know this is a problem for lots of people but I still cant find an
answer. I have imported a text file into excel with a number field that
displays credit card expiry dates as a 4 digit number. example 0408 so month
+ year. I have converted the number field to a text field so it doesnt drop
off the first zero and now I need to convert it to a date field. Any nice
easy simple ideas. Any help would be much appreaciated. Or direction to a
question the same.
format as date
--------------------------------------------...OWA Display Settings
Is there a method to clear the Web Access Display Settings (i.e. Color
Schemes, Preview Pane setup) from the server side of the application for
either a single user or all OWA users? Also, I've had several users report
that if they've attempted to access their OWA mailbox in FireFox, they lose
the way messages are normally displayed in the OWA client where each message
basically has two lines, one line for who it came from and when and the next
line for the subject. After logging to OWA with Firefox, all of the
information is displayed on a single line.
This is on a Windows...Problem changing wallpaper on Vista
I am trying to change the wallpaper on Vista. I have a sub that works on XP
with .jpg and .bmp images...
Private Sub SetActiveDesktopWallpaper(ByVal sFileName As String, ByVal
lStyle As Long, ByVal fForce As Boolean)
Dim ad As ActiveDesktop
Dim co As COMPONENTSOPT
Dim wpo As WALLPAPEROPT
Set ad = New ActiveDesktop
'check if AD is enabled
co.dwSize = Len(co)
ad.GetDesktopItemOptions co, 0&
.dwSize = Len(wpo)
.dwStyle = lStyle
' set wallpaper style...
.SetWallpaperOpt...set a reminder to print or edit in an excel document
Is there a way to set a reminder to print part of a workbook or edit a
workbook on a certain day. I need to print and edit a workbook on a certain
day at a certain time, but I can never remember to do this. Is there any way
of setting a reminder alarm or notification.
> Is there a way to set a reminder to print part of a workbook or edit a
> workbook on a certain day. ...
If you have Excel, you might be using Outlook also. Both are part of
Outlook has a "calendar" feature that pops up reminders the user can
schedule. I use it all the ti...Statment of changes in financial position
i will be a demo of GP 10 on Weds for a customer who has a requirement for a
statement of changes in financial position. Is there any reason that this
would be a problem in FRx as long as i know what GL accounts make up each row?
Their sales and receivables are going to be maintained in another systmer -
with that system providing a journal entry either weekly or monthly.
How did this come out for you, also have you done a Schedule of Changes
Report?? Pretty standard non-profit reports.
"Andrea Smiley" wrote:
> i will be a demo of GP 10 on Weds for a cus...Corporate Name Change
How does one change the name of a stock (and symbol) when
a company (such as AOL) decides to do so
Select AOL from your portfolio, right click and choose "see details"
You can rename it and change the symbol there.
"Wade" <email@example.com> wrote in message
> How does one change the name of a stock (and symbol) when
> a company (such as AOL) decides to do so
Thanks ... I get an error stating the ticker is already
in use. How can I get around this (is there a global
ticker li...changing sort order
I have followed the TK "How to BCP Data Out and Back into a New Database
(875179)" a few times and it seems to work great. However, when bcp'ng the
data back in, I do notice some errors as it flashes by in the dos screen,
however, NONE of the .err files show any size other than 0k. After logging
into Great Plains, I do notice that some information is completely missing.
I check the tables and they are empty. I checked the in and out bat files
and those tables are exported, then imported, the table is empty and its .err
file is also blank.
If the .err files do not show...And introducing... The Default Text Box Add-in!!
Default Text Box for Publisher 2002/2003 allows you to save defaults for
text boxes in Publisher 2002 (which before now has been impossible) and to
save these defaults for use in future publications (which isn't even
possible with Publisher 2003!)
Download it now from http://www.mvps.org/the_nerd/Publisher/add-ins.htm
Go on, give it a go - it's free!
Ed Bennett - MVP Microsoft Publisher
Before reading this message, view the disclaimer:
I don't want add-ons for 2002 - I want 2003!
"Ed Bennett" <...Changing Exch5.5 GAL columns in Outlook client view
Sorry if the subject line is a bit cryptic; anyway, in the Outlook client, if
you display the 'Address Book' you get the following columns - name, business
phone, office, title, company, alias, e-mail type, & e-mail address. How do
you change it so you show the display name, business, extension, cell phone,
& internet email address?
Basically, how/where do you change the columnar data the client sees?
Thanks, Mike Lawson
Goto View | Columns and there u can manage views...
"Mike Lawson" wrote:
> Sorry if the subject line is a bit cryptic; anyway, i...Dropdown Size: How do I change?
I have a workbook and after opening it on another computer, all the
dropdowns are way too wide.
And how can I have them show 20 items rather than the default of 8?
Right-click the dropdown and you can change the 8 to any other number.
To make it less wide, right-click it and drag the right/left border to the
size you want.
It MAY have something to do with the screen resolution on the other
"Craig Roberts" <Somewhere @ Lindstrom Minnesota USA> wrote in message
>I have a workbook a...How can I change primary display for presentation on multiple mon.
I want to hit F5 and have my presentation go to a different monitor. I have
multiple monitors so my laptop display on a classroom screen. Can I change
the default monitor that F5 points to?
In article <5A95BBFC-B291-4A05-9E71-3F094B937ABB@microsoft.com>, Shorebilly
> I want to hit F5 and have my presentation go to a different monitor. I have
> multiple monitors so my laptop display on a classroom screen. Can I change
> the default monitor that F5 points to?
In the Slide Show | Set up show dialog, you can choose the monitor you want to
display slide s...Outlook keeps making itself Default
Everytime I start Outlook it takes over as default for email and addresses
even though I have that option unchecked in outlook, and in IE I set OE
Express as default, yet each time I launch outlook it takes over as Default,
...start app without setting focus
i want to start my app (modless dialog) and I do not want, that my
application gets the focus.
How can I realize that? I tried such tings like
GetForeGroundWindow()->SetFocus, but nothing worked. Everytime my app
has the focus (wether running hidden with tray icon or showed). Does
anybody has some ideas how I can do that?
thanks a lot,
In CDialog::OnInitDialog() return FALSE instead of TRUE
Visit me at http://alok.bizhat.com
"I Believe this will Help"
"Holger Krei�l" <n...need basic help setting up a graph
I am trying to set up a chart of days and times. The X- axis shoul
have the days of the week (mon, tues, etc) and the Y - axis should hav
various times of the day. I would like to have a line from on
specific time on one day to another specific time on the next. So,
point would be monday at 10:00 and the next would be tuesday at 1:00
followed by wednesday at 12:00, etc. Any suggestions?? Thanks fo
Message posted from http://www.ExcelForum.com
See my attachment. Is that the situation you explained?
I use formula
in column ...pointer changes from arrow to plussign
Somehow the pointer arrow in excel has changed from an
arrow to a plus sign. How can I change it back to an a n
That would depend upon where you are pointing the cursor.
If anywhere on the cells portion of a worksheet, the cursor is a fat white
If pointing to menus, toolbars, sheet tabs or scrollbars the cursor should be
Are you saying your cursor "never" changes to an arrow?
Gord Dibben Excel MVP
On Wed, 14 Apr 2004 19:15:34 -0700, "gmohanco"
>Somehow the pointer arrow in excel has c...Free/Busy data setting in OWA
We implemented Exchange 2003 and pushed a client setting to all users to
extend the number of months available in free/busy to 12 months with a group
policy. It works fine if everyone is using the outlook client when they are
in the office. But, if a user works at home one day or goes to a conference
and does anything that updates the free/busy data, the OWA overwrites the
users free/busy data setting it back to 2 months of free/busy available.
Where can I set the free/busy data number of months available, in OWA? Is it
a policy setting?
On Wed, 31 Jan 2007 13:54:01 -0800, SKS <sks...Set Left and Right Margins in Headers and Footers
How do I set the left and right margins in headers and footers in Excel
Select, File, Page Setup and the Margins tab.
Productivity add-ins and downloadable books on VB macros for Excel
"Simon" <firstname.lastname@example.org> wrote in message
> How do I set the left and right margins in headers and footers in Excel
Thank you for your response
While I can see that this sets the Vertical position (Top and Bottom) of the headers and footers it does not set the...Coping Saw w/ 5 Pc Blade Set
Best deal: http://thediscountlocator.info/index.php?id=B0006UOV8G
Coping Saw w/ 5 Pc Blade Set Zinc plated steel body construction. 3 ½ Lacquered hardwood handle is small enough not to get in the way yet large enough to get a good grip. Very thin and compact design makes it easy to get into tight areas. 5 tempered blades: 1- medium for cutting woods, 1-fine for thick metal or hardwood, 1- extra fine for thin metal or thin woods, 2- hacksaw blades for all metals. Blades are easy to replace, just unscrew the ha...Email Sent from Workflow tracked twice in history
I have a workflow that sends an email to two CRM users. After the
email arrives in the two users' inboxes, there are 2 history
activities created for the email - one owned by the id we use for
email routing, the other owned by the person who fired the rule. Any
idea why this happens and what we can do to stop it? Thanks!
Could you look at Settings - Organization Settings - System Settings. On the
third tab you wil find the following:
Set whether to exclude e-mails between Microsoft CRM users
Exclude e-mail Yes/No
Setting this option to No will create one e-mail activity for out...Strange message tracking and NDR
Can anyone explain this tracking log?
19/10/2006 13:00 SMTP: Message Submitted to Advanced Queuing
19/10/2006 13:00 SMTP: Started Message Submission to Advanced Queue
19/10/2006 13:00 SMTP: Message Submitted to Categorizer
19/10/2006 13:00 SMTP: Message Categorized and Queued For Routing
19/10/2006 13:00 SMTP: Message Queued For Local Delivery
19/10/2006 13:00 SMTP: Message Delivered Locally to email@example.com
19/10/2006 13:00 SMTP: Non-Delivered Report (NDR) Generated
The NDR was also unhelpful; the error code appears to be 5.2.1 but the
message was only 32K.
On Thu, 19 Oct 2006 15:0...changing the message list in outlook 2003
i just upgraded from office 2000 to 2003. in the message look in
outlook, it separates the messages by date. is there any way to turn
this off, so i just have a long list of messages?
Right click on the header in the message list, uncheck "show in groups."
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the SWEN virus, all mail sent to my personal account will be deleted
After searching google.groups.com and finding no answer, Lee Benningfield
| i just upgraded from office 2000 to 2003. in the mess...