Hi
I need an Excel VBA Guru who can hep with the following:
I have 3 csv files that all reside in the same folder.
- Upon launching or using some button I want to import the CSV data into 3 tabs / sheets
- Once imported I want a line graph creating for Sheet 1 & Sheet 3 (if it exists) >> Sheet 1 and Sheet 3 layout is the same except the values.. if sheet 3 exists then overlay the graph already created from sheet 1
The graph will be per column and must be presented well.
Each Column must have a separate graph with Column A as the date which is static. So first Graph will hold Data for Columns A $ B, 2nd will hold A&C, A & D etc till all the columns are finished. The columns can change so you must manage this within the graph.
The data in the rows will grow daily with present day data added daily in the csv file.
You can either do a fresh import and generate graphs or just import the new raws and have the graphs automatically update.
The attached rar file has the 3 csv files which have been imported into a sample workbook and graphs created manually to give you an idea of what I am looking for.
I reckon someone who knows their stuff should be able to complete this i about 2 hours.
Please only bid if you are serious and bid the realistic amount.