Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking data across worksheets???
Hi I have a new spread sheet and i want to drag the info
from one sheet to another i know how to do this ='Raw Data'!I$4 for example but the data i am retreving is changing daily because it is a formula to get a avg. Is there a way of once you get the data to store it so that when i enter the next days data in the raw data sheet the avg will change for only that day and the previous day will stay the same. If anyone can help me that qwould be great thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking data across worksheets???
When you do your paste, do a paste special "value" and
you will hae only the value and not the formula. -----Original Message----- Hi I have a new spread sheet and i want to drag the info from one sheet to another i know how to do this ='Raw Data'!I$4 for example but the data i am retreving is changing daily because it is a formula to get a avg. Is there a way of once you get the data to store it so that when i enter the next days data in the raw data sheet the avg will change for only that day and the previous day will stay the same. If anyone can help me that qwould be great thanks. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking data between worksheets | Excel Worksheet Functions | |||
Linking data from various worksheets | Excel Worksheet Functions | |||
Linking data on different worksheets | Excel Discussion (Misc queries) | |||
Linking between worksheets- then sorting data | Excel Worksheet Functions | |||
Linking Data between worksheets in a workbook | Excel Worksheet Functions |