Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking Data from 1 sheet to another sheet
Hello.
I would like, if possible to set up an automatic link so that sales data that I have on one sheet is automatically copied into a different sheet. Is this possible and if so can anybody help me with some instructions please? -- Regards, Warwick |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking Data from 1 sheet to another sheet
Maybe I don't understand your question, but can't you just set the cell in
sheet2 equal to the cell in sheet one you want duplicated? ='sheet1'!B3 where sheet1 is the name of the first sheet and B3 is the cell reference. "Warwick Everett" wrote: Hello. I would like, if possible to set up an automatic link so that sales data that I have on one sheet is automatically copied into a different sheet. Is this possible and if so can anybody help me with some instructions please? -- Regards, Warwick |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking Data from 1 sheet to another sheet
Here's what I do if it will help you:
Select the cell in the new sheet you want copied data to appear in. Type = in that cell Click the original sheet tab and selct the cell you want data copied from Hit return The copied data should appear in the new sheet. It will also carry any changes from the original sheet. "Warwick Everett" wrote: Hello. I would like, if possible to set up an automatic link so that sales data that I have on one sheet is automatically copied into a different sheet. Is this possible and if so can anybody help me with some instructions please? -- Regards, Warwick |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking Data from 1 sheet to another sheet
Thanks very much Tomeck.
That has worked. My understanding of Excel is very basic so being able to seek help from people like yourself is very useful. Happy Christmas -- Regards, Warwick "tomeck" wrote: Maybe I don't understand your question, but can't you just set the cell in sheet2 equal to the cell in sheet one you want duplicated? ='sheet1'!B3 where sheet1 is the name of the first sheet and B3 is the cell reference. "Warwick Everett" wrote: Hello. I would like, if possible to set up an automatic link so that sales data that I have on one sheet is automatically copied into a different sheet. Is this possible and if so can anybody help me with some instructions please? -- Regards, Warwick |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking Data from 1 sheet to another sheet
Thanks Allewyn.
I am an Excel novice so I really appreciate the help. -- Regards, Warwick "Allewyn" wrote: Here's what I do if it will help you: Select the cell in the new sheet you want copied data to appear in. Type = in that cell Click the original sheet tab and selct the cell you want data copied from Hit return The copied data should appear in the new sheet. It will also carry any changes from the original sheet. "Warwick Everett" wrote: Hello. I would like, if possible to set up an automatic link so that sales data that I have on one sheet is automatically copied into a different sheet. Is this possible and if so can anybody help me with some instructions please? -- Regards, Warwick |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking Data from 1 sheet to another sheet
Anytime :)
"Warwick Everett" wrote: Thanks Allewyn. I am an Excel novice so I really appreciate the help. -- Regards, Warwick "Allewyn" wrote: Here's what I do if it will help you: Select the cell in the new sheet you want copied data to appear in. Type = in that cell Click the original sheet tab and selct the cell you want data copied from Hit return The copied data should appear in the new sheet. It will also carry any changes from the original sheet. "Warwick Everett" wrote: Hello. I would like, if possible to set up an automatic link so that sales data that I have on one sheet is automatically copied into a different sheet. Is this possible and if so can anybody help me with some instructions please? -- Regards, Warwick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple sheets as data for a single sheet | Excel Worksheet Functions | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
Transfer data from sheet to sheet | Excel Discussion (Misc queries) |