Linking data across worksheets???

  • Thread starter Thread starter Rod
  • Start date Start date
R

Rod

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.
 
When you do your paste, do a paste special "value" and
you will hae only the value and not the formula.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

switch to another worksheet, then return to original sheet 2
Copy Destination 5
Dynamic worksheet selection using messagebox 3
hide multiple worksheets based on a formula value in one cell 1
Excel Move or Copy Stopped Working? 0
Macro to Combine Data from Multiple Sheets with Cell References 4
Active sort / Copy 3
Query from Access Database based on user selected parameters in Excel 2

Back
Top