Closed

Excel. Import data from csv to an excel file and automate some processes.

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.

Skills: Excel, Data Processing, Visual Basic

See more: mysql import csv excel, import excel sheet sql data base, search data csv excel vba, data multiple excel file single file, howto export data csv excel format php mysql, quickbooks excel import file, excel macro vba import csv text file, data manipulation excel csv file, excel import fixed width text file template, excel import data from text file, import data into excel from another excel file, excel macro import data from text file, import data from excel file to database table in asp.net mvc 5, import data into excel from text file, import update bulk product from any csv excel file pro, automate import data from excel to access, how to import data into excel from text file, how to import data from excel file to sql server database in asp.net mvc, how to import data from excel file to oracle database by using oracle forms

About the Employer:
( 3 reviews ) aigaleo, Greece

Project ID: #32204966

16 freelancers are bidding on average €32 for this job

VladimirLilenko

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 More

€30 EUR in 3 days
(179 Reviews)
6.8
AccountantArman

"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 More

€77 EUR in 1 day
(125 Reviews)
6.1
(69 Reviews)
5.2
(36 Reviews)
5.5
mhfsha

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 More

€30 EUR in 1 day
(84 Reviews)
5.2
alexandraboteza1

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 More

€25 EUR in 1 day
(10 Reviews)
3.8
(1 Review)
3.0
(3 Reviews)
2.4
Moeinsalari

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

€30 EUR in 1 day
(0 Reviews)
0.0
AndreiSokolov

===== 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 More

€25 EUR in 7 days
(0 Reviews)
0.0
Gershonselorm

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 More

€25 EUR in 7 days
(0 Reviews)
0.0
PrithviNegi

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 More

€25 EUR in 7 days
(0 Reviews)
0.0
vilasjambhulkar

Hi, Gone through your requirement. I would like to help. I will help you to finish this project in expected time.

€25 EUR in 7 days
(0 Reviews)
0.0
Kels4real

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. More

€25 EUR in 7 days
(0 Reviews)
0.0
marelica33802

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 More

€25 EUR in 1 day
(0 Reviews)
0.0
yusranaveed17

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 More

€20 EUR in 2 days
(0 Reviews)
0.0