Data export in a Calendar sheet - VBA
$30-250 USD
Paid on delivery
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!
Project ID: #4306825
About the project
15 freelancers are bidding on average $102 for this job
Hello, I am offering you to make this VBA code till the end of the week. Please see private message for details.
Dear RazvanFratila, your need is not really complicated. Please have a look at my PM. Best regards
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!
Dear Razvan Fratila, This is not difficult at all. VBA Expert here and can do in no time.
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.