ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   copy data (https://www.excelbanter.com/excel-discussion-misc-queries/97664-copy-data.html)

Elvis

copy data
 
I want to copy the data from cells c1, c2, f64, etc... different sheets and
paste the info. on a new sheet. Can someone please explain to me in "dummy
words" how I can do this.

Bill Ridgeway

copy data
 
To copy current data - but not permanently -.
You could copy and paste -Click on the cell FROM which you want to copy data
Click on <Edit<Copy
Click on the TO which you want to copy data
Click on <Edit<Paste

To copy current data permanently and which and will update automatically-
Click on the cell TO which you want to copy data
Type =
Click on the cell FROM which you want to copy data
Press <Enter
This will produce a formula which is a direct link between the two cells.

I hope that helps!

Bill Ridgeway
Computer Solutions

"Elvis" wrote in message
...
I want to copy the data from cells c1, c2, f64, etc... different sheets and
paste the info. on a new sheet. Can someone please explain to me in
"dummy
words" how I can do this.





All times are GMT +1. The time now is 03:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com