Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

General Discussion

Posted by Mathijs Gast
Mathijs Gast
10,439 Points

Variable field size in excel

Hi all!

I have a question about a project in excel, I am wondering what the best way is to create a specific kind of template.

The user of this template has to fill in the booklets he printed on a certain day. There are 8 different booklets he could print and there are some fixed costs for the entire day.

So the thing is, he could print just one or multiple booklets a day (a different row for every single one). Is there any way in excel to make this field variable, so the user could choose to add another empty field with the same calculation formula's in it? For the next day there has to be a new field again. I am quite new to VBA but I have some general programming knowledge. Does any of you know if there is a way to manage this.

I hope some of you could point me in the right direction where to look for.

Thanks in advance.

Mathijs