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

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

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

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

64-Bit W7 Ult_sp1
 
 

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

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 for2: Can one cell be instantly copied to another?
Thread Forum
Solved BSOD instantly on entering windows BSOD Help and Support
My Graphic card is not detected instantly ..!! Graphic Cards
Solved Lock screen instantly on login! BSOD Help and Support
Computer restarts almost instantly in some games BSOD Help and Support
Computer instantly shut off mid-use. BSOD Help and Support
System Image Fails ... Instantly Backup and Restore
IE8 crash instantly after launch 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 04:05 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33