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: Can one cell be instantly copied to another?

14 Aug 2011   #1
lister

Windows 7 Panasonic CF F9 (used to have CF F8)
 
 
Can one cell be instantly copied to another?

Is is possible to enter data in say cell A1 and then whatever is inputted in A1 is also placed in E1?

Thanks!!!


My System SpecsSystem Spec
.
14 Aug 2011   #2
seavixen32

Windows 7 Ultimate SP1 64-Bit
 
 

You haven't said what the purpose is, but the easiest way is to just enter the very basic formula =A1 in cell E1.

As you enter data in A1 and update the cell contents, E1 will automatically be updated.
My System SpecsSystem Spec
14 Aug 2011   #3
lister

Windows 7 Panasonic CF F9 (used to have CF F8)
 
 

thanks for that - i also discovered that this works as well: =Sheet1!B2 - this would copy B2 Over.

The purpose is just to copy that exact english language data over so say "London" is in B2 - I also need that in D2 which would be the better formula, mine or yours or are they the same you reckon?

Thanks
My System SpecsSystem Spec
.

14 Aug 2011   #4
BugMeister

Windows10 Pro - 64Bit vs.10547
 
 

the addition of "Sheet" just means that you can work from multiple pages, but the nature of the thing is basically the same..

some time ago, I ran up an Excel prog to do my business accounts, and the "Sheet" instruction
featured quite often, to transfer data to and fro from the Capital and Accounting modules..

it's useful when you want to do a projection
you can update a single entry and see what the effects are..
great for passing data to a graph, etc..
My System SpecsSystem Spec
14 Aug 2011   #5
lister

Windows 7 Panasonic CF F9 (used to have CF F8)
 
 

thanks
My System SpecsSystem Spec
Reply

 Can one cell be instantly copied to another?




Thread Tools




Similar help and support threads
Thread Forum
Can I compare 2 Excel spreadsheets cell by cell?
I have an Excel 2010 workbook comprising a simple organization membership list, consisting of names, addresses, etc., for nearly 2,000 members, grouped into 5 chapters' sheets, in a single Excel 2010 file. Every time I sit down to enter updates for any member, or add new members, etc., I always ...
Microsoft Office
6 Cell Vs 9 Cell Battery for Laptop?
Someone needs to get a new battery for a very old laptop they have. The battery doesn't work so they have to have it plugged all the time otherwise it wouldn't work. Laptop is 15.6 and sort of heavy but the thing is they never take the laptop outside the house. It will mainly be used on one floor...
Hardware & Devices
Laptop keeps shutting off instantly, don't know why :(
I was playing a game on my laptop when all of the sudden my laptop shuts off instantly. This has happened to me twice in the past week and I don't know why it does this. Can anyone explain me why this is happening? My laptop is an HP Envy Dv7-7223cl with Windows 7 Ultimate.
Performance & Maintenance
All windows reduced instantly: What could cause that
Hello I got an intermittent problem where all my opened windows will be reduce instantly while I drag fast one of them across my screens My system use 4 monitors driven by two Nvidia graphic card. I don't loss anything because my application are still running in background. When the...
Graphic Cards
Computer instantly shut off mid-use.
Is Windows 7 . . . - x86 (32-bit) or x64 ? x64 - the original installed OS on the system? No - an OEM or full retail version? Full retail - OEM = came pre-installed on system - Full Retail = you purchased it from retailer
BSOD Help and Support
IE8 crash instantly after launch
Hey, i am running windows 7 ultimate. my internet explorer 8 was automaticly installed when i installed windows 7 ultimate, it used to work fine but now it crashes immediatly after launching i have ran ie8 with no add-ons but it still crashes. i have uninstalled and re-installed numerous times and...
Browsers & Mail


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 21:29.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App