Data Entry Form: Day# = Sheet #

[Mooncake]

I'm doing a form that tracks data entered in real time. I've created a box where the user enters the day of the month (i.e. 1,2,31). I want to make that number refer to the corresponding sheet in the same workbook, where entered data entered will populate. It's not an elegant system by any means, but it's what the boss wants. Can anybody help, please?

If number in "Form" Cell F4 = #, Then Sheet # Cell A2

 

[James006]

Hi,

Are you coding a UserForm ...?

Not sure to understand the User interface ...

 

[Mooncake]

I manually created a form on a sheet. I've done no coding...yet.
Much like https://www.youtube.com/watch?v=9j8mAJGFWPg

 

[James006]

If my understanding is correct ... you are using a Data Form which reads and writes records in the database located in the same worksheet ...

If that is the case, with a Data Form, you cannot interact with another sheet inside your workbook ...

You will have to create a UserForm for that matter ...

 

[Mooncake]

Thank you! You just saved me a LOT of time

 

[James006]

You are welcome ...