Hello

I am new to this forum. Never used excel so much and recently started using it and admire the features of it.
My boss has assigned me a project and I want to achieve many things and I am researching online on how to do this. Here is what I have achieved now and would like to take a step further with help from experts. I use Excel 2010 and I have 2 questions.

Question 1:

I get two excel reports daily say a.xls and b.xls from the server autogenerated and it drops to a particular share folder.
I open b.xls and run a macro (basically deletes non bold rows) and save it. Then I do a vlookup on this file and add a column to the file a.xls and my final report is ready.

Is there a way to automate this ?

1) run the macro automatically when b.xls file is dropped in a particular folder. I dont even need to open this excel file at all.
2) do the vlookup function automatically and get the final a.xls file.


Question 2:

Month Mar Apr May Jun
Used Space (GB) 100 123 135 166
Free Space (GB) 400 377 365 334

I have the above table and I need to plot a chart and do some forcasting or projection for the future months and get one final big dot mark when the free space reaches a certain value lets say 50Gb free so I go and buy more space. Just want to see when I will hit that threshold value so I can plan myself better.

I just know how to plot a chart and I dont know how to do the projection/ forecasting etc.

regards