I have an Excel workbook that had 3 sheets, and each one contains a very basic table. Is there any way that I can have a 4th sheet, where a user will click 'New Table Entry' and depending on what they input, it will go into the correct table?
For example, the 3 tables are called Central, East and West. On the 4th sheet I'd like a little form where you select/type 'Central', 'East' or 'West' and then fill the other details such as Customer Number, Customer Name and Customer Address. Then depending on whether they've entered Central East or West, it will then enter into the correct table on the correct sheet.
Is this possible?
For example, the 3 tables are called Central, East and West. On the 4th sheet I'd like a little form where you select/type 'Central', 'East' or 'West' and then fill the other details such as Customer Number, Customer Name and Customer Address. Then depending on whether they've entered Central East or West, it will then enter into the correct table on the correct sheet.
Is this possible?