Pivot Table ( Report)
Budget: $10 – $30 USD
Develop a report, and this report should be updated on a daily basis, and the data also changes on a daily basis. First: Every day I receive data for two destinations, I convert the data of each party separately into a csv file in Excel, and they consist of three files, Float, String, Tagname, then I take only the Float file for each destination and create a Pivot table for it, and then after that These two files must be merged into one single Excel file, and then converted to a txt file.
All csv files are in one folder and each file has a specific date, so I need to create buttons to put the desired date for the current day and automatically, when pressed, it imports the required file from the folder on the specified date. After that, I need to create another button that creates a pivot table for the two files (Float) and merges the two files together into one file in Excel. Then finally I need another button to convert this file after merging, into a txt file.
“All this steps by using (VBA) code.”
All csv files are in one folder and each file has a specific date, so I need to create buttons to put the desired date for the current day and automatically, when pressed, it imports the required file from the folder on the specified date. After that, I need to create another button that creates a pivot table for the two files (Float) and merges the two files together into one file in Excel. Then finally I need another button to convert this file after merging, into a txt file.
“All this steps by using (VBA) code.”