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.
15 freelancers are bidding on average $102 for this job
I had rewrote VBA code already, included in attached Excel Workbook to be able to include new possibility, which you require. See description of result along with deadline of project in PM.
Hello, I have 8+ years experience in Excel/VBA. I can start immediately. I am sure I can complete this in less than one day. Let me know if I may be of service. Thanks!
I had a look at your sheet. A lot is unnecessarily done by macro's. I could do a quick fix, or i could redo the whole sheet (takes 2-3 days) to make it better fit it's purpose.