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.
Bu iş için 16 freelancer ortalamada €32 teklif veriyor
"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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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
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 Daha Fazla