#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Copy Data

Good day;

First of all, I would like to thank you. You helped so many times.

Example;;;

Sheet-1, Cell A1 = Milk

Sheet-2, Cell B1 = Can I copy the Cell [Sheet-1, Cell A1],?

The word (Milk) will appear'!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default Copy Data

hi
not entirely sure what you mean but see if this is what you want...
on sheet 2 cell B1, enter
=sheet1!A1
what ever is in cell A1 on sheet 1 will appear in Cell B1 on sheet 2

Regards
FSt1

"Khalid A. Al-Otaibi" wrote:

Good day;

First of all, I would like to thank you. You helped so many times.

Example;;;

Sheet-1, Cell A1 = Milk

Sheet-2, Cell B1 = Can I copy the Cell [Sheet-1, Cell A1],?

The word (Milk) will appear'!

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Copy Data

Thank you so much, this is the second time you help me in.

That exactly what I want;

But one final question; Can I Copy the Formula also.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Copy Data


Sorry, i ment the format


"Khalid A. Al-Otaibi" wrote:

Thank you so much, this is the second time you help me in.

That exactly what I want;

But one final question; Can I Copy the Formula also.

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Copy Data

Formulas don't work that way. They return values--not formats.

Khalid A. Al-Otaibi wrote:

Sorry, i ment the format

"Khalid A. Al-Otaibi" wrote:

Thank you so much, this is the second time you help me in.

That exactly what I want;

But one final question; Can I Copy the Formula also.


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How copy none excel data & paste in 2007 without overwriting data Wakefootin Excel Discussion (Misc queries) 2 October 8th 09 12:15 AM
filted data, copy and paste a col. puts data in wrong row how fix chris_fig New Users to Excel 1 October 16th 06 04:26 PM
Retrieve multiple data rows data from a very long list and copy t mathew Excel Discussion (Misc queries) 1 September 13th 06 08:24 PM
How do I copy data from main frame computer and keep data in cell Doug Excel Worksheet Functions 1 May 30th 06 05:15 PM
Copy old Data from web query while keeping previous days data DRobidoux Excel Worksheet Functions 0 March 22nd 06 01:56 PM


All times are GMT +1. The time now is 08:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"