Help with links in excel worksheets

cdo1ca

New Member
Joined
Nov 14, 2005
Messages
2
I am new to excel, and would like some help. I have a workbook that has one worksheet that I use for a daily balance sheet and another worksheet for a monthly spreadsheet. I use the daily balance sheet to balance my office everyday so the figures are cleared and entered daily. I would like to link some of the daily total figures to my monthly spreadsheet which has a column for each day of the month. I know how to paste the link for the cells I need, but my problem is how can I keep them from changing when I change the figures in the source cell the next day? Every day of the month will have a different total for cash and stock and I need these numbers to remain unchanged after the linked value is shown for that particular day, on my monthly spreadsheet. Your help would be greatly appreciated/
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,812
Messages
5,833,801
Members
430,233
Latest member
cbutts

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top