Lectricman
New Member
- Joined
- Feb 18, 2016
- Messages
- 14
Good afternoon all,
For more than 3 years I have been happily entering data into an Excel based database and everything works rather well.
However, I need a little advice on a problem I have not got a solution for.
All data is entered by way of a multi-tabbed userform, I would also like the data to be written to a closed workbook when the user clicks add data. Both workbooks save data in an identical format. I can filter, copy and paste no problems but if possible I would like this to be done at the same time.
Many thanks in advance.
For more than 3 years I have been happily entering data into an Excel based database and everything works rather well.
However, I need a little advice on a problem I have not got a solution for.
All data is entered by way of a multi-tabbed userform, I would also like the data to be written to a closed workbook when the user clicks add data. Both workbooks save data in an identical format. I can filter, copy and paste no problems but if possible I would like this to be done at the same time.
Many thanks in advance.