Generating a new form daily/user (preferably by selecting the date)

[kons45]

Hi all,

First post on these forums. I'm unsure if what I want is possible but I know excel is a marvelous program. I have some basic skills in Excel and am wondering if I can somehow create the following.

I have created a sheet where when staff come and collect inventory daily and we record the number of items taken. This is done daily for 3 different staff. The problem is I'm going to have 1 form per day per staff for each month which becomes a lot of Sheets

I'm wondering if there is a way to generate a new blank form by selecting the date. So for 1st October, I'll record items drawn from Staff A. When I change the date to 2nd Oct it shows a new blank form having saved the data in the first form. There should also be a running total, per item, on a separate sheet.


If it is unclear what I am saying I'm more than happy to clarify. Thanks everyone!

[AliGW]

Welcome to the forum!

You'll need VBA for this, so I'm moving the thread to the VBA section.

[kons45]

Welcome to the forum!

You'll need VBA for this, so I'm moving the thread to the VBA section.

Thank you.