Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Want to copy data and formula from one Excel Sheet to another.

16 Feb 2011   #1
BomberAF

Windows 7
 
 
Want to copy data and formula from one Excel Sheet to another.

I have a budget workbook set up in Excel, and in that workbook there are many different sheets all part of the one book.

I have created a formula in one sheet from the data that is collected there, and that data is important for information collected on another sheet. I want to copy the formula and the data from that from that sheet and have it appear in the other excel sheet. I also want the data to change on the second excel sheet as the results from the formula change in the first sheet.

When i have tried to just copy and paste the formula from one sheet to the next I just get a ref error.

Many thanks for your help in advance.

Regards

Anthony


My System SpecsSystem Spec
.
16 Feb 2011   #2
richc46

Microsoft Community Contributor Award Recipient

Windows 10, Home Clean Install
 
 

My System SpecsSystem Spec
16 Feb 2011   #3
BomberAF

Windows 7
 
 

Quote   Quote: Originally Posted by richc46 View Post
That didnt really help much.

It stopped giving me the ref error, but it didn't bring the fomula over from worksheet to another.
My System SpecsSystem Spec
.

16 Feb 2011   #4
Irene

Windows 7 Home Premium 64bit
 
 

Open both spreadsheets.

In the location of the second spreadsheet (SS) press the = sign, then switch windows to the first SS from which you want the second to be updated. Touch the cell in SS number one and press enter. That process will link the two spreadsheets and the 2nd will be updated when the first one is...

Whew, hope that doesn't sound too complex! It is actually relatively straight-forward. Just don't press anything else between the two stokes.
My System SpecsSystem Spec
16 Feb 2011   #5
BomberAF

Windows 7
 
 

Quote   Quote: Originally Posted by Irene View Post
Open both spreadsheets.

In the location of the second spreadsheet (SS) press the = sign, then switch windows to the first SS from which you want the second to be updated. Touch the cell in SS number one and press enter. That process will link the two spreadsheets and the 2nd will be updated when the first one is...

Whew, hope that doesn't sound too complex! It is actually relatively straight-forward. Just don't press anything else between the two stokes.
I have done an ECDL advance but the only way to learn and remember is to actually find practical things to actually use Office products
My System SpecsSystem Spec
16 Feb 2011   #6
Irene

Windows 7 Home Premium 64bit
 
 

Exactly what I have done for the past 30 years.

I started out in the 'DOS' world, when vdu's were black background screens with white, green or orange coloured words on-screen. Mice were something found in a field! In those days we used Lotus or SuperCalc for spreadsheets and WordPerfect or WordStar for word processing.

When they introduced Windows and mice into the office, I used to spend break-times playing solitaire to try learning to control my mouse.

My System SpecsSystem Spec
Reply

 Want to copy data and formula from one Excel Sheet to another.




Thread Tools




Similar help and support threads
Thread Forum
Excel 2013 - how to keep a formula consisten
Hi I am trying to tie one cell into a formula that is being pasted into multiple rows. I know you can use $ to keep the cell consistent but it doesn't seem to be working. So if the value is in c9 and then first row gets c9 then the new row gets c10 etc... I need it to be c9 throughout the...
Microsoft Office
Excel Formula
Hello Sir, Can you let me know the formula in Excel: I have a table as below: This table, At the column "A,Status" when i Put the word" Completed", it's will automatic put current Date to Column "B, Row 2". But i don't know after that when tomorrow arrived,at the column "B,Row 2",...
Microsoft Office
Excel 2013 Opening Size of Sheet
First, I always close sheets in the position and size that I want them to open in. However, with my new Office 2013, when I open a sheet, or even first open Excel and it comes up with a new sheet, it's opens in a small window and the window is positioned in the left lower quadrant of my screen,...
Microsoft Office
Excel 2003 sum formula problem
I have been entering currency data in Column B in Euros to an EXCEL 2003 s/s and the formula used has added these totals entered in that Column correctly until I reached a total sum of 74364.70 Euros ,this being the sum of entries in Rows B6 to B82 . This was reached with the formula showing as...
Microsoft Office
Printing Excel-sheet
Hi, I recently began learning Office 2010 and have an Excel specific question. The thing is, when I print an Excel-file I prepared the print is real tiny, almost unreadable as if the sheet should be divided into 6 or 7 pages rather than the 3 pages that I have somehow managed to get it down to. It...
Microsoft Office
Excel Formula Help please...
This is probably very simple and I have got it working but it isn't working how I want it to work. I have created an Excel document to show my monthly payments of a bank loan. I have created 3 columns in the first column is the payment number, in the second column is the amount that the loan...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 08:51.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App