Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 20th 10, 06:39 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2010
Posts: 1
Default transfer cell value from 1 sheet to another without copy/paste?

I need to enter a value 1 time and have it appear on additional sheets,
without copying and pasting to other sheets. Please help. I'm trying to

  #2   Report Post  
Old April 20th 10, 06:49 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2009
Posts: 833
Default transfer cell value from 1 sheet to another without copy/paste?

EXCEL 2007

Try this:-

1. In Sheet1 cell A1 I type (for example):-

hello

2. In Sheet2 cell A1 I type:-

=Sheet1!A1

This pulls in the word:-

hello

- from Sheet1 cell A1.

There are other ways to do this.

If my comments have helped please hit Yes.

Thanks.



"sbmiller" wrote:

I need to enter a value 1 time and have it appear on additional sheets,
without copying and pasting to other sheets. Please help. I'm trying to

  #3   Report Post  
Old April 20th 10, 06:51 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,276
Default transfer cell value from 1 sheet to another without copy/paste?

Hi,
Are you entering the value in the other sheets in the same cell? if yes
select your sheet, then press CTRL and click in the other sheets, all sheets
will be highlihgted, then go to the cell and add the value, the value has
been added to all the other sheets

"sbmiller" wrote:

I need to enter a value 1 time and have it appear on additional sheets,
without copying and pasting to other sheets. Please help. I'm trying to

  #4   Report Post  
Old April 20th 10, 06:51 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2010
Posts: 457
Default transfer cell value from 1 sheet to another without copy/paste?

Either set the other sheets to have formulas to reference the original
sheet:
='Sheet 1'!A1

Or select all the sheets at the same time (Use Shift and/or Ctrl) and then
type your value.

--
Best Regards,

Luke M
"sbmiller" wrote in message
...
I need to enter a value 1 time and have it appear on additional sheets,
without copying and pasting to other sheets. Please help. I'm trying to





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
transfer contents from a cell in previous sheet if the sheet is a DarkNight New Users to Excel 1 September 9th 08 01:04 AM
Copy from one Sheet and paste on another sheet based on condition Prem Excel Discussion (Misc queries) 2 December 24th 07 06:05 AM
Transfer text w/o Copy&Paste Excel Curious Excel Discussion (Misc queries) 0 June 13th 06 07:28 PM
Active Cell Copy And Paste Sheet to Sheet A.R.J Allan Jefferys New Users to Excel 4 May 4th 06 02:04 AM
Transfer/Copy Sheet, Dynamically linked Sheet 0-0 Wai Wai ^-^ Excel Discussion (Misc queries) 2 December 23rd 05 11:04 PM


All times are GMT +1. The time now is 06:29 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017