Project Description:
Hi,
I have attached a Excel document template which needs to be improved. Now, the Excel file works like this:
• in 'Manage events and actions' worksheet there is a form which one-by-one events can be added from. The database sheet is 'Global database'
• events are displayed in the 'Overview' calendar worksheet according to the date of the event (there are 4 test events there)
• out of all event details that may be added via the form, only certain data is displayed in the 'Overview' calendar: the abbreviation of 'Target' information ('Seniors' is selected and [SE] is displayed), the event name and the specific fill color for each country
The improvement we need is the ability of copy/paste several event rows in the 'Global database' worksheet (same header structure, same cell format etc.) and the events info should be displayed in the 'Overview' worksheet.
If prompted for a password when trying to access the VBA code, just press OK, no password is added.
I would need a price and timeline for this project.
Thank you!