Nadine
New Member
- Joined
- May 12, 2020
- Messages
- 32
- Office Version
- 365
- Platform
- Windows
Hello and thank you for any attention my post may receive.
Is it possible or good practice to have an excel add-in to store data? The single add-in will be used on two computers only.
The user's will save/paste data from their input pages to a single worksheet in the add-in on a twice-daily basis.
Only one of the user's workbooks will be used to retrieve/report the data from the add-in worksheet.
And can formulas be used in the add-in worksheet?
I know I can develop a more formal database, but due to business restrictions this is not possible, i.e. MS Access is not an option - Excel is one of the few applications the business allows.
Or should I just create a third workbook for the two user workbooks to save/paste to? I do not want to create a shared-workbook environment.
Is it possible or good practice to have an excel add-in to store data? The single add-in will be used on two computers only.
The user's will save/paste data from their input pages to a single worksheet in the add-in on a twice-daily basis.
Only one of the user's workbooks will be used to retrieve/report the data from the add-in worksheet.
And can formulas be used in the add-in worksheet?
I know I can develop a more formal database, but due to business restrictions this is not possible, i.e. MS Access is not an option - Excel is one of the few applications the business allows.
Or should I just create a third workbook for the two user workbooks to save/paste to? I do not want to create a shared-workbook environment.