Return End Value of Column where Column Length Changes

TQO23

Board Regular
Joined
Apr 18, 2004
Messages
58
Morning All.

I have a cell, C5, that displays the final figure in a column (H). Each day I add new lines to the worksheet which means I have to go back into C5 and change the column H cell so that it shows the uptodate value, ie start of day balance is shown in H43, 7 lines added so new end balance is displayed in H50. Go into C5 and change to =H50.

I've tried to record a macro using the End Down keys but it doesn't work.

Ideally I'd like the value in C5 updated whenever I open or close the workbook. If I could get a macro to do this I could alse create a button on the sheet and assign it so that I can update it when I'm working on the sheet.

C5 is also referenced from another workbook which provides a summary of different workbook balances.

Any ides please?

Regards

TQO23
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Hi Aladin and many thanks for responding.

Don't know where you got this from but after a couple of false starts it is working fine.

Will now look at some of my other spreadsheets where I have similar problems.

Many thanks again.

TQO23
 
Upvote 0

Forum statistics

Threads
1,222,398
Messages
6,165,767
Members
451,986
Latest member
samwize

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
Back
Top