ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I import cells from seoerate sheets? (https://www.excelbanter.com/excel-worksheet-functions/62309-how-do-i-import-cells-seoerate-sheets.html)

White Clay

How do I import cells from seoerate sheets?
 
I'm trying to sett up a workbook of weekly time sheet s w/ a monthly tally on
a seperate sheet and want the values from the weeklys to be automatically
added on the monthly.

Gary L Brown

How do I import cells from seoerate sheets?
 
On your Weekly and Monthly tallies, have a column for month. Reference that
column using the SumIf function.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"White Clay" wrote:

I'm trying to sett up a workbook of weekly time sheet s w/ a monthly tally on
a seperate sheet and want the values from the weeklys to be automatically
added on the monthly.



All times are GMT +1. The time now is 07:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com