Go Back   Computer Forums > General Computing > Software and Operating Systems
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 03-13-2013, 07:10 AM   #1
Wizard of Wires
 
setishock's Avatar
 
Join Date: Feb 2005
Location: Not sure
Posts: 10,030
Default Office 2013 Excel question

I needed a version of Office to put on my new rig and with the Office 2010 starter no longer available, I bought Office 2013. I'll get to the point.

I'm dinking around figuring out how to make formulas for spread sheets and even figured out (finally) how to get it to save them. I have 2 sheets I use for work of my own making but would like to do something different.
One sheet is my daily report. The other is a running total of the tax deposits. What I'd like to do is have the daily tax entry on the daily work sheet also appear on the tax running total sheet.
I know I can add the running total on the work sheet but I think it might be confusing for the accountant at the home office. Besides cluttering up my daily work sheet.
Any way to do this?
__________________

setishock is offline   Reply With Quote
Old 03-13-2013, 07:45 AM   #2
Fully Optimized
 
jmacavali's Avatar
 
Join Date: Jun 2009
Posts: 4,867
Default Re: Office 2013 Excel question

Could you explain a little better what you want. Without seeing the two worksheets it's a bit confusing.
Daily Report - Sheet1
Tax Deposits - Sheet2

You want a total from Sheet1 to show up on Sheet2?

I think what is confusing the most is the last sentence. Up to that point I thought you wanted something from Sheet1 on Sheet2, but when you say 'clutter up my daily work sheet (which I've labled sheet1)' it seems backwards to me....
__________________

__________________
****************************************
Don't take life too seriously -- no one gets out alive. Plus, who wants to arrive to the hereafter in pristine condition wearing a suit and tie?
I want to slide in sideways, worn out, used up, hair a mess, clothes tattered, & screaming, "Whooo! What a ride!"
****************************************
jmacavali is offline   Reply With Quote
Old 03-13-2013, 07:52 AM   #3
Fully Optimized
 
strollin's Avatar
 
Join Date: Mar 2011
Location: USA
Posts: 1,938
Default Re: Office 2013 Excel question

First of all, there are workbooks that contain multiple worksheets. Are the 2 worksheets part of the same Workbook or in different workbooks?

If they are in the same workbook then it's extremely easy to reference a cell in another worksheet, just use the reference format of 'Sheet2'!A1 where 'Sheet2' is the name of the sheet you want to reference and A1 is the cell you want to reference on that sheet.

If the data you want to access is in another workbook, then you need to create what's called an external link. Here's an article that explains it: Create an external reference (link) to a cell range in another workbook - Excel - Office.com
strollin is offline   Reply With Quote
Old 03-13-2013, 09:34 AM   #4
Wizard of Wires
 
setishock's Avatar
 
Join Date: Feb 2005
Location: Not sure
Posts: 10,030
Default Re: Office 2013 Excel question

I want to take cell xx data on sheet 1 and have it appear in cell yy on sheet 2,

No they are not in the same workbook.
setishock is offline   Reply With Quote
Old 03-13-2013, 09:40 AM   #5
Fully Optimized
 
jmacavali's Avatar
 
Join Date: Jun 2009
Posts: 4,867
Default Re: Office 2013 Excel question

The link from strollin is what you want. To paraphrase from the link:

Open the workbook that will contain the external reference (the destination workbook) and the workbook that contains the data that you want to link to (the source workbook).
1. Select the cell in the destination worksheet where you want to create the external reference and type = (equal sign).
2. Switch to the source workbook and select the cell that you want to link to.
3. Return to the destination workbook, and notice that Excel adds the reference to the source workbook and the cell that you selected in the previous step.
That should do it. Just played around with it and it works well. Updates properly and everything. Not sure what will happen though if you want to email the files to someone else and it opens and looks for the reference to the other workbook and can't find it. You could solve that by right before sending it off, going into that one cell, copying the data, right click and do a paste but choose 'value' instead of just paste. It will then stop referencing the other workbook and just have the value in there (you'll of course have to reset up the formula though).
__________________
****************************************
Don't take life too seriously -- no one gets out alive. Plus, who wants to arrive to the hereafter in pristine condition wearing a suit and tie?
I want to slide in sideways, worn out, used up, hair a mess, clothes tattered, & screaming, "Whooo! What a ride!"
****************************************
jmacavali is offline   Reply With Quote
Old 03-13-2013, 09:49 AM   #6
Wizard of Wires
 
setishock's Avatar
 
Join Date: Feb 2005
Location: Not sure
Posts: 10,030
Default Re: Office 2013 Excel question

I'll scope it out. Thanks guys.
setishock is offline   Reply With Quote
Old 03-13-2013, 10:10 AM   #7
Fully Optimized
 
strollin's Avatar
 
Join Date: Mar 2011
Location: USA
Posts: 1,938
Default Re: Office 2013 Excel question

I tested what happens when you email the sheet. When you open the workbook, excel will report that it contains links to other workbooks and gives you the choice of continuing with the current data (last value entered on external worksheet) or updating the links. If you send both workbooks then the user could update the link to point to the location where the 2nd workbook is saved.
__________________

strollin is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 02:33 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0