I have an excel file that I want to be able to insert data from a list of csv files that will be located in the same folder as the excel file.
More in depth, i want to:
1. Import CSV data in our “Report” Sheet. The csv file is created from another timesheet software and saved in a folder (for example “Data”) with specific name (as created by the timesheet software) in order to indicate the date of the exported file and the week that represents. The csv files will be located in the same folder as our excel.
The files will be named in the following form “[login to view URL]”. The csv file may have more columns in the future, therefore, when data are inserted, this should be taken into account.
Keep in mind that we are using windows with Greek characters and our excel is using ,(comma) instead of .(dot) for numbers and this should be taken into account when inserting the data
2. There will be something like a drop down menu in the sheet “Pivot4” that should look like a drop down menu that the user will be able to select the week of the year that wants to see. When a week is available the colour should be black, and if not available, it should be grey to indicate that there are no files with the specified data for this paqrticuloar week. The drop down menu should start with the latest week and should not include weeks that don’t exist yet. The same thing could be done with a caledary if it is prefered.
3. The data of Pivot4 will be inserted in the “Database” sheet. When the button “Insert to database” is clicked then all the filters in the slicer should be removed, collapse the entire field in the pivot table and insert the values in the sheet called Database (see picture with example bellow
In the case that the data of this specific week are inserted, then thereshould be a worning message and if accepted, the old data should be deleted and get replaced by new.
16 freelanceri licitează în medie 32€ pentru acest proiect
Hello! I am ready to carry out your project in the reasonable price and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f From the Microsoft Excel, of c Mai multe
"Sir, This is only possible if a macro is written for these procedure which will automate all this task. I am Excel Macros, VBA and Coding Advanced Level Expert. This is basic work for me. I can complete this project Mai multe
Hello Sir/Madam Ready to start now. I can do your project with 100% accuracy. I have reviewed your project brief carefully and would like to assist you with the task.I have 8 years experience of data processing virus Mai multe
Hello, I'm a Romanian girl who has just completed a master degree and I would like to help you with knowledge that I gained during my 5 years of college and 2 years of freelancing. I quickly learn anything and anytim Mai multe
dear, im expert in ms office and google sheet , Iam vba programer and can make automatic process for You. if you want please come to chat chat is free. Regards
===== Expert of Excel amd ExcelVBA, Macro HERE===== Dear Client! I am Andrei, experienced programmer from Russia. I have read your requirement and I noticed that I am appropriate to this project. As a skillful software Mai multe
Dear Client! I am Gershon, experienced in Microsoft suite from Ghana. I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with Excel amd ExcelVBA, Macro and built ma Mai multe
Hi, I'm Prithvi, a Data Scientist with over 5+ years of experience. I have read your requirements and I assure that I'll give you quality work within the stipulated time. For more details we can connect over chat. Re Mai multe
Hi, Gone through your requirement. I would like to help. I will help you to finish this project in expected time.
Hi prospective Client! I have checked the project details very carefully. I am very sure that I can do the Data entry - web srapping job with 100% accuracy. I have many years of experience in data entry, web scraping. Mai multe
DEAR SIRS I AM A GRADUATED ECONOMIST. 38 YEARS OLD. I HAVE 13 YEARS OF WORK EXPERIENCE IN OFFICE. I AM FROM BOSNIA AND HERZEGOVINA. MARRIED. I HAVE TWO CHILDREN. I REALLY NEED MONEY. PLEASE GIVE ME A JOB I WILL DO PERF Mai multe
Hello Dear Client, I have 3+ year of experience in Microsoft Excel. Excel has been may passion since always and I would really solve your problems in Excel. I desire to exceed customer expectations every time. If you Mai multe