Excel File Modification with Pivot Table data connection and vba
Budget: $30 – $250 NZD
I have an excel file that needs some modifications, primarily using a Pivot Table. The main purpose of the project is to analyze data, create reports, and summarize information.
file imports all files in a folder via data query (this is already done)
but we need to pass a path to teh query that user selects (selection done, passing to query not done)
then add sorting and minor to the pivot)
pls look at the main file, i will send data files to you when you start.
its 2 hours +- if you know data connections and pivots well.
file imports all files in a folder via data query (this is already done)
but we need to pass a path to teh query that user selects (selection done, passing to query not done)
then add sorting and minor to the pivot)
pls look at the main file, i will send data files to you when you start.
its 2 hours +- if you know data connections and pivots well.