Home Automatically add new sheet to formula
Reply: 0

Automatically add new sheet to formula

user528
1#
user528 Published in July 15, 2018, 9:17 pm

I have a sheet which calculates the total numbers for whole year. I plan to create separated sheets for each month.

How can I make the Year sheet, so its calculations would automatically count the new sheet?

Example: 1. January - I've got general sheet/tab called YEAR 2016 and another called JAN. 2. February - at the end of February I create sheet called FEB. I want YEAR 2016 to sum positions in these two sheets by automatically expanding formulas range.

Preferably without VBA.

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.309372 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO