immediate help

on close of a workbook a cell value should be written to another workbook
0
sak1 (2)
6/19/2009 10:36:02 AM
excel.newusers 15348 articles. 2 followers. Follow

6 Replies
307 Views

Similar Articles

[PageSpeed] 51

Why is your request so much more important than all of the others?

-- 
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"sak" <sak@discussions.microsoft.com> wrote in message 
news:95549E21-720E-4631-B124-E62A5A44061E@microsoft.com...
> on close of a workbook a cell value should be written to another workbook 

0
dguillett1 (2487)
6/19/2009 12:41:25 PM
How about linking that cell in the other workbook to the cell in the workbook 
that you are about to close, that way it's always current in that other 
workbook?

Process:
Open both workbooks.  In the "other" workbook, choose the cell that you want 
to have the value written to and type in the = symbol.  Then choose the other 
workbook (the one that is the one you eventually want to close) and choose 
the sheet and cell that is to be written from.  Press the [Enter] key.  Job 
done.

"sak" wrote:

> on close of a workbook a cell value should be written to another workbook
0
JLatham (219)
6/19/2009 2:41:01 PM
That is just so damned rude, from the subject to the tone of the note.


"sak" <sak@discussions.microsoft.com> wrote in message 
news:95549E21-720E-4631-B124-E62A5A44061E@microsoft.com...
> on close of a workbook a cell value should be written to another workbook 


0
ken.wright (2489)
6/19/2009 10:49:57 PM
Just for my take on it - I try not to judge by tone of post in an 
international community.  Quite often a politely phrased request, once run 
through something like BabelFish, can lose quite a bit in translation.
After having helped to moderate a very large website for some 7 years, I 
learned that this 2-dimensional communication media leaves much to be desired 
in the way of actually catching nuances of tone of voice or meaning.
Basically boils down, for me, that if I don't like the tone of a post, I 
just move on to the next one without devoting any time to it or worrying 
about it any further.

"Ken Wright" wrote:

> That is just so damned rude, from the subject to the tone of the note.
> 
> 
> "sak" <sak@discussions.microsoft.com> wrote in message 
> news:95549E21-720E-4631-B124-E62A5A44061E@microsoft.com...
> > on close of a workbook a cell value should be written to another workbook 
> 
> 
> 
0
JLatham (219)
6/20/2009 11:39:01 PM
I know, and I don't usually bite to be honest, but that one just pushed a 
button.

Regards
                Ken......................


"JLatham" <JLatham@discussions.microsoft.com> wrote in message 
news:459CAA3F-4D26-47E8-B86D-8923C0376E8E@microsoft.com...
> Just for my take on it - I try not to judge by tone of post in an
> international community.  Quite often a politely phrased request, once run
> through something like BabelFish, can lose quite a bit in translation.
> After having helped to moderate a very large website for some 7 years, I
> learned that this 2-dimensional communication media leaves much to be 
> desired
> in the way of actually catching nuances of tone of voice or meaning.
> Basically boils down, for me, that if I don't like the tone of a post, I
> just move on to the next one without devoting any time to it or worrying
> about it any further.
>
> "Ken Wright" wrote:
>
>> That is just so damned rude, from the subject to the tone of the note.
>>
>>
>> "sak" <sak@discussions.microsoft.com> wrote in message
>> news:95549E21-720E-4631-B124-E62A5A44061E@microsoft.com...
>> > on close of a workbook a cell value should be written to another 
>> > workbook
>>
>>
>> 


0
ken.wright (2489)
6/21/2009 7:30:37 PM
Yeah, we all bite from time to time.  And if it was determined that the OP 
had phrased it that way intentionally to get a rise out of folks in the 
forum, then some moderator would come along and ding him for 'trolling'.  
Hell of it all, in the case of the site I helped out with, was that usually 
the guy/gal that came along and took the bait got in more hot water than the 
original troll because that button had gotten pushed and their response was 
usually less than well thought out.  It's a strange world.
Of course, since these forums really don't seem to have much in the way of 
moderator control, and no way to edit posts, stuff tossed at the fan tends to 
stick on whatever the fan slung it on to, LOL.

"Ken Wright" wrote:

> I know, and I don't usually bite to be honest, but that one just pushed a 
> button.
> 
> Regards
>                 Ken......................
> 
> 
> "JLatham" <JLatham@discussions.microsoft.com> wrote in message 
> news:459CAA3F-4D26-47E8-B86D-8923C0376E8E@microsoft.com...
> > Just for my take on it - I try not to judge by tone of post in an
> > international community.  Quite often a politely phrased request, once run
> > through something like BabelFish, can lose quite a bit in translation.
> > After having helped to moderate a very large website for some 7 years, I
> > learned that this 2-dimensional communication media leaves much to be 
> > desired
> > in the way of actually catching nuances of tone of voice or meaning.
> > Basically boils down, for me, that if I don't like the tone of a post, I
> > just move on to the next one without devoting any time to it or worrying
> > about it any further.
> >
> > "Ken Wright" wrote:
> >
> >> That is just so damned rude, from the subject to the tone of the note.
> >>
> >>
> >> "sak" <sak@discussions.microsoft.com> wrote in message
> >> news:95549E21-720E-4631-B124-E62A5A44061E@microsoft.com...
> >> > on close of a workbook a cell value should be written to another 
> >> > workbook
> >>
> >>
> >> 
> 
> 
> 
0
JLatham (219)
6/22/2009 12:55:01 AM
Reply:

Similar Artilces:

Newbie
I have installed Exchange 2003 (new install) on a new install of Windows Server 2003. When I went to add info for the SMTP server (using Exchange Management System - EMS) I navigated to Servers - Exchange1 - Protocols - SMTP There's no default SMTP server listed in there. How can I get one in there? -Fran- Did you have IIS installed already? <Fran> wrote in message news:vmrpu1h04d06lpot07kbqu78lnsflpqcaa@4ax.com... >I have installed Exchange 2003 (new install) on a new install of > Windows Server 2003. > > When I went to add info for the SMTP server (using Exch...

Need offset function help, I think
I have 10 products rows with a cost in column BW of rows 21 thru 30, i.e., cells BW21 down to BW30. Those 10 products have the # of units sold each month, for 22 months, shown in rows 41 thru 50, in columns E thru Z, so column E is month #1 ... col Z is month #22. The total range is cells E40 thru Z40. There is a cost factor vector that has six factors in row 70, cells G70 thru L70. These are to be used =91for all time periods=92 and for all products. Any time there is a sale of a product in a certain month, I want to enter six months of cost associated with producing the item...

How zoom/increase font size of Office 2004 "Help" text?
Font sizes can be set for Word, Excel and Entourage. You also can zoom in to enlarge the View of text in Office 2004 components� documents. How does one do this with the small-font text in Help? Respectfully, Norm On 9/14/04 1:36 AM, in article BD6BFBA9.49F3%nnager@vnoxsxpxaxmv.fullerton.edu, "Norman R. Nager, Ph.D." <nnager@vnoxsxpxaxmv.fullerton.edu> wrote: > Font sizes can be set for Word, Excel and Entourage. You also can zoom in > to enlarge the View of text in Office 2004 components� documents. > > How does one do this with the small-font text in Help...

Please Help #2
I am trying to share out a users calander to a group of managers. When I go to properties on the calander it adds them ok. When I go to add them in the properties under the users mailbox in Outlook 2002 on Windows NT it gives me the message "The modified permission could not be saved. The client operation failed." I have read article 323611 on a workaround, but this did not work. We are using Exchange 2000, and I know when I started my predisesor was backing up the M drive on the Exchange server, so when I look at the security settings on the users box on the M drive it...

flag for follow up Help
Using Microsoft Outlook 2000 SP-3. My Flag for Follow Up quit working, in my in box, but I can flag in other folders. Anyone else ever have this problem? Please advise. Thank you, Chris Jametski ...

New Outlook user needing help
After trying to sync my mobile phone & Pocket PC with Outlook 2000 on my computer the '+' prefix (i.e. + 44 1234 567890) which I have for all my telephone numbers do not show up in Outlook contacts. Even when I enter the '+' manually at the beginning of the number when I press save it disappears. What is most annoying of all is when I sync my phone with outlook again it even replaces all the numbers in my phone without the '+'. Can someone shed some light as to what settings I need to go into to resolve this problem...Many thanks ...

help-planning
We carry circa 25 products. Each product needs to be processed in 2-3 stages. circa 20 minutes/ stage. Raw materials come in several times a month. However for some products the raw materials are readily available while for others 1-2 months are necessary. Each product is packaged differently. Each consignment consists of a product mix. (between 1 and 25) There are circa 5 large customers (2000 products/month) , 5 medium ones (200/ month) and 10 small ones (20/month). (but none of these order every single month). At the moment most customers need to wait circa 2 months but the planning must be...

What is wrong with this IF statement? need help.
This statement works fine but I want the cell to say 0" if the cell H6 has a zero in it. As the stetments stands right now it displayes 6" in the cell if H6 is 0. How can I make that happen? =IF(H6<101,"6""",IF(AND(H6>101.1,H6<151),"7""",IF(AND(H6>151.1,H6<201),"8""",IF(AND(H6>200.1,H6<275.1),"9""",IF(AND(H6>275.2,H6<350.1),"10""",IF(AND(H6>350.2,H6<601),"12""",IF(AND(H6>601.1,H6<901),"14"""))))))) Pleas...

help me please
Hello! I have a nice problem for you - so please help me! I have a property sheet with three pages in it. I make a pointer to the doc class. I receive a value from the doc class. When I�'m going to use that value - the value has changed, so I receive an exception. How can I get the right value from the doc class? Is a doc class' value a word or a dword? -- - Lars The doc class reference is a pointer. It is not a word, and it is not a dword, it is an address. This means it could be 64 bits on a 64-bit machine. Never assume that a pointer is 32 bits. The pointer to a CDocume...

Loven test for there help
...

Need some help from you smart people...
I have a spreadsheet that has multiple columns (13) that are variou milestones. These columns contain dates that range over a period o time given in day, month and year (11/18/2003). My question is, how ca I filter, sort, etc...by a given date range i.e. for a 3 month period? I hope that this is clear enough to get some feedback. Thank you. Healu ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com If I understand your intent, you need to use Data > Filter >AutoFilter....

Help with Excel Workbook
I am updating a workbook and very behind. It's a construction workbook, so there many separate categories that have to total costs For example, electric, plumbing, misc....etc...and then theres a totals page. What is the easiest way to input info? Can I input all info on one page. thanks Not sure if this has anything to do with Outlook. You might have better luck posting in an Excel newsgroup. "Nina" <Nina@discussions.microsoft.com> wrote in message news:0E171EE5-5679-4210-9D00-E7649A0FB909@microsoft.com... >I am updating a workbook and very behind. It's a...

Please help w/formula
I want to create a formula for an employee schedule to compute the totals hrs scheduled, multiply total hrs scheduled by rate of pay to get a gross rate of pay. I can only get it to add up to 24 hrs then it starts over at 1. Example I am using: Start:17:00 End: 19:00 Total: =(end-start) =IF(A3<A2,A3+1-A2,A3-A2)*24*B2 Where A2 is start, A3 is finished, B2 is rate of pay Format cell to currency or accounting. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Dave" wrote: > I want to create a formula for an employee schedule to co...

New to excel Help
hello I am new to this forum and not good with excel. this is a brief explaination of what i need to do to kick things off. hop somebosy can help have a calculation for temperature that i have 25 deg figures for. need to be able to create a excel calculation for any given value (i deg). I have a table of values run from a line of best fit basis. so far my equation is eg D1=(A1*B1)*C1 F1=D1/ratio in table pre determinded by the temp in E1 Can anybody help Scott sdminus@yahoo.co.u -- swa ----------------------------------------------------------------------- sway's Profile: http...

Frank Kabel...need your help
I've got MSQuery setup to retrieve data from an external database. I have a macro that automatically refreshes the data when the file is open. It's very cool because I've got it setup to prompt for the parameters (e.g., beginning date, ending date) I'd like to complete the automation of this spreadsheet by telling Excel to refresh all the pivot tables in this workbook, AFTER the data is DONE being downloaded. Hi Jonathan first: you may use a different header for this kind of postings: Just stae your problem and don't address a question directly to one of the regulars....

Trying to understand rules, please help
I have an Exchange 2003 and I needed to create aliases that would forward to several external email address (like jdoe@localdomain.com forwarding to jdoe@yahoo.com). What I did was to create a user named buttler@localdomain.com, assigned all the aliases to it (jdoe, janedoe, somebody and help) and create rules that will redirect based on "Sent to" to the external addresses. For better understanding of my problem I post two examples below: Apply this rule after the message arrives sent to jdoe@localdomain.com redirect to jdoe@yahoo.com and delete it and stop processing more rules A...

pivot table help #2
I am extremely new to pivot tables and trying to just get ave, max, and min of a couple of columns ... I keep getting #DIV/0! errors and don't know what the problem is. any ideas anyone??? -- evg1 ------------------------------------------------------------------------ evg1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35043 View this thread: http://www.excelforum.com/showthread.php?threadid=547887 Do you have errors in any of those fields in the raw data? Do you have any numbers in the field that you're averaging? evg1 wrote: > > I am ...

network key pw help
I have forgotten my network key pw for my wireless router my lap top has the pw saved so i can get onwith that pc but i need the pw so i connect with another lap to is there any way to retrive this pw??? I am useing the window connection for connection Thanks Mike Mike <Mike@discussions.microsoft.com> wrote: >I have forgotten my network key pw for my wireless router >my lap top has the pw saved so i can get onwith that pc but i need the pw so >i connect with another lap to is there any way to retrive this pw??? I am >useing the window connection for connection You wi...

Help! Need to add/delete email users
We are a nonprofit in a sticky situation - our old consultants are terrible and we are replacing them next week, but in the meantime I have a new assistant starting on Monday and need to get rid of the old assistant's email/login and set her up. I am the most skilled at computers in our office unfortunately, and am in the network room (luckily it is logged on) but have no idea where to find a place to change it or how to change it. I am guessing its not too difficult if I'm pointed in the right direction. We can't have the original consultants come in to do this so any...

Need HELP with HTML!
Subject: Need html help for MicroSoft Publisher 2000 From: "Barbara" <photosbybarbara@yahoo.com> Sent: 10/9/2003 7:10:17 AM I just recently designed a web page in microsoft publisher 2000 and uploaded to server, only to find out that I have NO CONTROL over html coding in pages because when saved as web page it saved every page as an "image map!!" Why?! Where is the coding. I know a little about html and this is not it! I just assumed when saved as html it would be saved in html coding!! I don't want to start over with another web design program such ...

Please help! MS Exchange Server is sending personal info!
I have all my personal banking, credit card numbers, passwords, drivers license #, ect, on in my contacts. And some sensitive info in notes. My company just changed to an inhouse server and is using ms exchange and it copied my contacts folder to the server, which can certainly be viewed by anybody in the office. And I run the risk of all this going everywhere. I went on the internet site and deleted everything I could, but now I can never go into outlook while being connected to the internet. Please help! What is the best solution? Thanks, Wendy Mark your contact properties in the permissi...

Can not receive Email.. Need Help
Hi all, Earlier this morning, my exchange server 2007 (hosted on SBS 2008) just stopped receiving external e-mail. We can send interoffice e-mails and we can send out e-mails to other locations fine, but we are unable to receive any e-mail. All internet connections are normal as well, and the port 25 is open on the firewall. The error from when we try to send an e-mail to the server is this: “This is an automatically generated Delivery Status Notification. Delivery to the following recipients failed.” Earlier today I installed the anti-spam update from MS “Microsoft excha...

Help please? #3
sorry thanks its working! : -- H4F ----------------------------------------------------------------------- H4Fi's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1625 View this thread: http://www.excelforum.com/showthread.php?threadid=27657 ...

Self joining table and grouping help
Hi All, Could some help me with the SQL without using PARTITION and RANKING functions? Or would that be asking too much? pk_id, parent_id, trx_date, amt ====================================== 1, 0, 3/7/2008, 2500 3, 0, 5/2/2008, 5000 48, 0, 12/4/2009, 2000 109, 0, 12/9/2009, 5000 101, 48, 12/6/2009, 2000 118, 48, 12/13/2009, 4000 145, 48, 12/13/2009, 2000 229, 48, 12/20/2009, 2000 313, 48, 12/27/2009, 2000 397, 48, 1/3/2010, 2000 482, 48, 1/10/2010, 48400 122, 109, 12/13/2009, 1365 149, 109, 12/13/2009, 5000 233, 109, 12/20/2009, 5000 317, 109, 12/27/2009, 5000 401, 109...

Excel 2003, Auto Filter Help!
I have a 21,000 row XML file that I pull into Excel every morning: Data / Import Data / Select Data Source / OK ...and all is well ....until I updated to a new PC and had to reload Excel. Now I get autofilters at the top of each column, and it won't load all the data. I know I can go in AFTER I load and uncheck Data / filter / autofilter and it will remove the filter queues on the top row, but I DON'T know how to set up an option where it will not format with auto filters from the get-go. ...so I can load this data completely. What am I missing here?! Thanks! - Hu - ...