Home Automatically add new sheet to formula
Reply: 0

Automatically add new sheet to formula

user5114 Published in September 19, 2018, 11:30 am

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.

share|improve this question
  • support.office.com/en-in/article/… – Axel Richter Sep 19 '15 at 13:51

1 Answer 1

active oldest votes
up vote 0 down vote
You need to login account before you can post.

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

© 2016 Powered by mzan.com design MATCHINFO