|
|
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
|
|
0
|
|
|
|
Reply
|
 Utf
|
4/20/2010 5:39:02 PM |
|
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
|
|
|
0
|
|
|
|
Reply
|
Utf
|
4/20/2010 5:49:02 PM
|
|
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
|
|
|
0
|
|
|
|
Reply
|
Utf
|
4/20/2010 5:51:05 PM
|
|
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" <sbmiller@discussions.microsoft.com> wrote in message
news:6F9414D2-9E61-46C7-9008-38D7B5B95141@microsoft.com...
>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
|
|
|
0
|
|
|
|
Reply
|
Luke
|
4/20/2010 5:51:49 PM
|
|
|
3 Replies
946 Views
(page loaded in 0.002 seconds)
Similiar Articles: 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 ... copying cell comment from one sheet to another - microsoft.public ...transfer cell value from 1 sheet to another without copy/paste ... If my comments have helped please hit Yes. Thanks ... How to Copy a Cell From One Sheet to Another ... VBA copy cell to another worksheet - microsoft.public.excel ...transfer cell value from 1 sheet to another without copy/paste ... VBA equivalent to SHIFT + Right click OPEN - microsoft.public.word ... transfer cell value from 1 sheet ... copy value only...Copy Destination:=Cells(3, 2) - microsoft.public ...transfer cell value from 1 sheet to another without copy/paste ... Copy. Right click on destination, Paste Special, values only? ... from one sheet to another ... copy one ... Copy Excel Worksheet to new Workbook via VBA without Links to ...... Work Sheet A").Range("a1:z100").Activate ' Remove Links and Replace with Cell Values ... sheet to another without copy/paste ... VBA ... new work ... VBA copy cell to ... Copy contents of a cell and paste it into text field - microsoft ...transfer cell value from 1 sheet to another without copy/paste ... Copy contents of a cell and paste it into text field - microsoft ... Copy and Paste Cell Contents to ... Maintain cell reference after value is moved - microsoft.public ...transfer cell value from 1 sheet to another without copy/paste ... Maintain cell reference after value is moved - microsoft.public ... I can copy and paste the value to ... paste values Excel 2007 - microsoft.public.excel.worksheet ...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 ... Move one cell to another - microsoft.public.excel.misctransfer cell value from 1 sheet to another without copy/paste ... Move one cell to another - microsoft.public.excel.misc transfer cell value from 1 sheet to another ... enter data in 1 cell and produce a number in another cell ...... Cell From One Sheet to Another ... one cell and then that data transfers to another ... of cell A1 to transfer ... without fixed decimal points), text, dates, or times in one cell ... 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 ... transfer cell value from 1 sheet to another without copy/paste?transfer cell value from 1 sheet to another without copy/paste? - answer - I need to enter a value 1 time and have it appear on additional sheets, without copying and ... transfer cell value from 1 sheet to another without copy/paste ...Excel Worksheet Functions ... I need to enter a value 1 time and have it appear on additional sheets, without ... EXCEL 2007 Try this:- 1. In Sheet1 cell A1 I type ... How to Copy a Cell From One Sheet to Another | eHow.com... Text from One Cell to Another in Microsoft Excel Without Copy & Paste ... Sheet to Another Sheet in a Specified Cell? If you want to transfer the cell contents of one cell ... How to Copy From One Worksheet & Paste to Another Using VBA | eHow.comDevX: VBA, Excel -- Copy Value ... to Copy Text from One Cell to Another in Microsoft Excel Without Copy & Paste ... How to Transfer Data From One Sheet to Another in Excel 7/20/2012 9:59:14 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
39 followers. 