Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

General Discussion

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.