In Sheet3 I have my formula ( e.g. MOD(H7)), and I want the result to be
copied automatically to Sheet1 - the value only. Which function would do it
On Tue, 15 Nov 2011 10:28:31 +0100, salonowiec wrote:
> In Sheet3 I have my formula ( e.g. MOD(H7)), and I want the result to be
> copied automatically to Sheet1 - the value only. Which function would do it
> for me?
Think about it this way: Excel doesn't copy results *to* cells, it
pulls results *from* cells.
In Sheet1, in the cell you want the result copied to, put this
(assuming P4...help!! #2
Hi. can anyone help me solve this formula on excel..
reddie12345's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28500
View this thread: http://www.excelforum.com/showthread.php?threadid=480997
see solution in your other post:
PLEASE don't multi-post, as this wastes the time of the volunteers who
spend time answering in one location when the problem has been already
solved in another...Signatures and formats, Help Please
Here is the situation:
- Outlook 2000 Workgroup Only format to send mail: HTML
- Exchange Server 5.5, provides messages for pop3 and imap: html.
- Outlook Express 6 (POP3 access) sends and receives as html.
all email clients have a png file as signature, inserted with html code.
(<img src= />
a) Outlook 2000 WO, sends email to another Outlook 2000 WO, signature Ok.
b) Outlook 2000 WO, sends email to Outlook Express 6 (or any other
client with pop3 access), signature NOT ok. (appears a red X telling me
that it can't find the file)
c) any other client (not our ...Counting frequency in unsorted data
hi...I'm looking for a function that will count frequency using multiple
variables in an unsorted data set using two variables. I can get the
information that I need by sorting the data and then using Data->Autofilter
and using the countif function ti isolate the variables individual. However,
this is problematic if the data gets re-sorted.
A B C
XA GM 125
XC BA 34
XA GM 23
XC NY 19
XA GM (blank)
I'm looking to count the number of occurrences of XA where the value of GM
i...Returns Issue pls help!
I have not been able to figure this out and i hope i am overlooking something
My warehouse staff had done partial receipts of a po and on the last receipt
then did it incorrectly.
the po only has two line items but on the final packing slip the items had
been listed inversley from the po. So this caused the warehouse staff to
under recieve one item and over recieve the other but everytime i try to do a
return i get an error
The quantity returned can't exceed 0. This is the maximum available based on
tthe item and receipt number. Please enter a smaller quantity to return....Problems with New Users
I have problem when I create a new user in Dynamics GP 8.0 and the user
wants to enter in the system inmediately appears in the following message:
A get/change operation on table 'SY_End_routines_Check_MSTR' failed
accessing SQL Data.
So I tried to delete but the users is blocking?
Any suggestions about this?
What service pack level are you on? Go to Help > About Microsoft Dynamics GP.
Que nivel de parche tienes? Ve a Ayuda > Acerca de Microsoft Dynamics GP.
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, L...Getting the tool tip text from a CToolBar
How can I get the tool tip text from a CToolBar? For instance, I want
to get the 5th button tool tip text in the CToolBar. I understand
about the ToolTipCtrl but can't find a away to get a single buttons
text. Any help would be appreciated. thanks.
"Jeremy R. Harner" <email@example.com> schrieb im Newsbeitrag
> How can I get the tool tip text from a CToolBar? For instance, I want
> to get the 5th button tool tip text in the CToolBar. I understand
> about the ToolTipCtrl but can't find a away to g...How to transfer Outlook files to new user installation or file server?
I have created a new Windows XP account and I want to transfer the the
Outlook email files from the old logins to the new login.
I have copied the Outlook pst files from the old accounts folder to the
new accounts folder, but when I open Outlook the mail contents are
there but it seems that Outlook does not remember the old email account
details. Is there a way to transfer the email accounts details as
The previous email accounts are still there with the original mailboxes
in the old logins, only the email account details not coming over.
It appears that they are not stored with the...Outlook sends mails in "Rich-Text" since SP2
I have problems with SP2! Since I have installed SP2, Outlook always
mails in "Rich-Text" though in Outlook's options Tools --> Options -->
is configured that new messages will be send in "Plain-Text".
I figured out this behavior when I sent an email with
an attachment to users who are using outlook express. All receipients
told me that they
have not received an attachment. Receipients of this mail which are
received the attachment.
Below you can see a part of the header:
This is a multi-part message in MIME format.
---...Change Users AD Name
We installed CRM with a domain admin and would now like to change the AD
entry for that user. We would like to know is there any CRM downstream
hazzard in changing that administrator's user name in AD?
Yes. Changing the AD login breaks the tie to AD as it looks at both the
login name and the SID. There are a few options to fixing this, I remember
seeing a KB article recently that outlined how to synch CRM up with this
type of change.
1) Go into Deployment manager and expand User manager
2) Right click on the account in question and select Change Account
3) Choose a new AD accou...HOW TO PASS THE VALUE TO CORRECT INPUT BOX ?
I am a new member in this group.. I have some dificulties in
form's date input box. I am trying to get date from a calendar and there are
two date input box. How do I pass the dates into respective input boxs. How
do I check the cursor whether is in Textbox1 or Textbox2 ?
Not quite clear on this.
When a control is invoked (entered), the events for that control fire. So
normally you would add code to the events for the specific control. So, the
user would type into Textbox1 say, and you could code in the Change, Exit
events, or any of the other events associated with ...Need help with Alphanumeric Auto number combination
Access 2000. I need a to assign an Audit number that is alphanumeric and
partially auto number and partially assigned by the user. Example: Audit
Number: 01086AB07 The first two digits of 01 is the first audit, which
will advance one number automatically for each audit (Textbox). The second,
third and fourth digits are the julian date which will be set to
default(Textbox). The fifth and sixth digits are assigned indicating a
company name(Combobox) for selection by user. The last two digits are the
year which will be set to default(Textbox). I need this alpanumeric sequence
to en...Dear God
I'm nearly going out of my mind trying to format a Mileage
Log in Excel 2002. My needs are specific and don't seem
to fit any of the ready-made templates out there. I need
the day-numbers in a month (1-31) down the left-hand
column. Excel (being written for nuclear physicists who
don't appear to bother with such things) won't allow me
just to enter numbers. Every number I type in those cells
comes out as 0. I have tried formatting the cells
to "Number" with no decimals, to no avail. (I am NOT
going to write in every number in this Log as "1.0"...Office 2008 doesn't install
when I tried to install it said it can't find software to install, just after choosing the install location. what's going on? I have office 2004 installed.
problem solved - I had to change the system language to english before installing!
...Error message when adding text to bar
-->Sorry, nothing happened when I hit the submit button, so I hit it
Microsoft Project 2000, I am trying to add text to the right of a bar
in a Gantt Chart. Don't I select "Right", then scroll down and choose
"Text1" change the text to what I want to say, and hit OK? When I do, I
get a pop up that says "This value is not valid in this situation, Chick
the field to see if it requires text, a date, or a number, and that you
typed the information correctly.
How do I do that? I thought I did...
Thanks for your help.
-...paste special | values should work with merged cells
When you use past special | values, and try to paste a large bunch of data
with merged cells into another sheet, it will not let you paste just the
values. This requires un-merging the cells. The problem that I have with
this, is that the error message makes NO sense. It says "This operation
requires the merged cells to be identically sized". Well, guess what? They
are!!! I just copied them in from another worksheet. I even used paste
special | column widths to ensure that the were indeed the same size. I
don't understand what the big deal is anyway? If Excel can ...Conditional Formatting Formula Help Part 2
I am working on a conditional formatting formula that will refer to a
different worksheet that the one it is in, I hope this can be done, so
here's how the formula needs to be:
in cell X2 of worksheet "10 DAY AVERAGES" I need a formula that tests
cell W2 in worksheet "PASTE DATA" to see if it's greater than the 20
day average of cells W2 through D2 in worksheet "PASTE DATA", and if so
I will program a certain highlighting color via conditional formatting,
I would appreciate very much some help with this formula
---------------...Excel file locked by user/process problem
I need help! We have a shared Excel file on the network. The las
person who worked on it on Saturday says he closed the file properl
and everything was fine. However, today, Excel keeps saying that he'
in it. I've asked him to reboot his computer. I've searched fo
temporary files in the folder where the file resides. Still couldn'
find anything. I tried deleting it with DOS and it still doesn't le
me because it says "The file is in use." I don't care who's using i
now. I just want to terminate the process and delete the file.
I was going t...hidden value in each cell or in each row in Excel
I need to store a two information in one cell with one value as hidden
,kindly reply if any one know the way
without creating hidden rows or columns or worksheet
The need is to store two information in one cell,with one value in
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
Using comments is one option.
>I need to store a two information in one cell with one
value as hidden
>,kindly reply if any one kn...Help! Can't boot even to safe mode. Can't re-install OS. 0xc000
I'm hoping some experts are on the discussion group here because I am
getting close to a dead end. I am trying to help a friend restore his
Windows XP installation. It's a real doozie. He has a very expensive CAD
program on it and wants to avoid at all costs wiping the hard drive clean and
losing the program -- for which he has no installation software... (I know,
that was a dumb thing to lose the installation software, but it's been my
experience that it's all too common among the non-geek population...)
--This is a Dell laptop, but there is no re...Charting Text #2
Below sample data I am trying to chart but I'm not sure if Excel can do this.
It is basically a record of animals (tags) and where they have been spotted.
I am trying to create a chart (maybe a scatter) with Location and Month on
the X & Y axis and the tag data to appear to show a sighting. I have created
a work around using a pivot table but the person looking at this chart is not
an Excel user and I want to keep it simple.
Location Month Tag
NW Jan J33
NW June J34
SW May J33
SW June J35
E Oct J36
E Nov J35
W May J33
W Apr J34
Insert new blank columns ...Chart data from text file
I have my x- and y- values as tab-separated values in a text file. There are
many different files, so it is too cubersome to open them all convert them
all to Excel.
Is there any way I can create a chart that reads its data from a text file?
On Sun, 16 Sep 2007, in microsoft.public.excel.charting,
hmm <firstname.lastname@example.org> said:
>I have my x- and y- values as tab-separated values in a text file. There are
>many different files, so it is too cubersome to open them all convert them
>all to Excel.
>Is there any way I can create a chart that reads its data fr...Formula help...
I need help in devising a formula that will subtract 100 hours from a
specific date and time. For example, if I entered a date and time (1/20/04
@ 1140) I would like the formula to subtract the 100 hours and give me that
date and time (1/16/04 @ 0740). Is that possible?
If you enter your date and time as a real date and real time:
You can just subtract the 100 hours (100/24 represents 100 hour)
and format as mm/dd/yyyy hh:mm:ss
(or your favorite date/time format)
1 = 1 day = 24 hours. So 100/24 is really 4.167 days (or 100 hours).
&...partner programs... need help..
I used to work on restaurant POS software, and try to work on MS RMS.
I was looking at the MS partner programs, but couldn't find information
about MS RMS reseller(or partner) program.
So.. which partner program do I have to get in?
First become a Registered Partner - you just have to sign up, there's no
Then you'll need to take an exam at a testing center to become certified to
sell RMS Store Operations. If you want to sell Headquarters, there is an
Your first stop should be http://partner.microsoft.com - once you become a
register...HTTP_300 error when useing Active Sync, any clues would help
First I was recieveing an HTTP_500 certificate problem, but I got that
straightened out by following this article
http://support.microsoft.com/kb/817379/en-us, the option # 2. Now I get
an HTTP_300 error. Any thoughts??
What version of the server are you running?
What platform are you running the server on?
> First I was recieveing an HTTP_500 certificate problem, but I got that
> straightened out by following this article
> http://support.microsoft.com/kb/817379/en-us, the option # 2. Now I get
> an HTTP_300 error. Any thoughts??