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 freelancers are bidding on average €32 for this job
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