Paul Naylor
Board Regular
- Joined
- Sep 2, 2016
- Messages
- 98
- Office Version
- 365
- 2003 or older
- Platform
- Windows
- Mobile
- Web
Hi, hoping someone can help
I have a number of weekly spreadsheets with data on daily tabs ( which comprise of work c/f & new work in and completed) and a weekly total tab with work c/f , new work in and completed for each day.
What I need is a formula that will display the contents of a cell based on the value of 2 cells added together.
E.g. weekly total worksheet
Column C is daily carried forward totals ( Monday is in C7) let's say value is 500
Column D is Daily New In figure ( Monday is D7) let's say value is 1000
So I need a formula ( or VBA) that will display the contents of the sum of these(1500) or the last entry on a particular column of a specified sheet column D ( which will be the time of the last entry on the sheet) this will allow me to check all work been added without actually opening the spreadsheets.
Anyone any ideas best way to achieve this
Kind Regards,
Paul
I have a number of weekly spreadsheets with data on daily tabs ( which comprise of work c/f & new work in and completed) and a weekly total tab with work c/f , new work in and completed for each day.
What I need is a formula that will display the contents of a cell based on the value of 2 cells added together.
E.g. weekly total worksheet
Column C is daily carried forward totals ( Monday is in C7) let's say value is 500
Column D is Daily New In figure ( Monday is D7) let's say value is 1000
So I need a formula ( or VBA) that will display the contents of the sum of these(1500) or the last entry on a particular column of a specified sheet column D ( which will be the time of the last entry on the sheet) this will allow me to check all work been added without actually opening the spreadsheets.
Anyone any ideas best way to achieve this
Kind Regards,
Paul