Lee Rabbit
New Member
- Joined
- Apr 30, 2020
- Messages
- 43
- Office Version
- 2010
- Platform
- Windows
Hi Guys/Gals,
Can you tell me the most efficient way to complete this task.
I have a user form with 2 text fields and I want to populate the next empty cell in a defined range (A1:A100)
As I populate the database I need the textbox 1 input into A1 cell and textbox 2 into B1 cell of a sheet named TEMPLATE
As I add new data, I want the next empty cells below to populate with the new data.
I am pretty competent with my understanding of arrays but this is giving me a bit of a headache as I am struggling with dynamic population
Thank you in advance, much appreciated.
Regards, Lee
Can you tell me the most efficient way to complete this task.
I have a user form with 2 text fields and I want to populate the next empty cell in a defined range (A1:A100)
As I populate the database I need the textbox 1 input into A1 cell and textbox 2 into B1 cell of a sheet named TEMPLATE
As I add new data, I want the next empty cells below to populate with the new data.
I am pretty competent with my understanding of arrays but this is giving me a bit of a headache as I am struggling with dynamic population
Thank you in advance, much appreciated.
Regards, Lee