Macro on excel files -- 2

I have 2 excel spreadsheets with multiple worksheets in which I have to add one data point each month on each worksheet. I would like to be able to put all the new monthly data in a separate worksheet and for the rest of the file, the graphs and tables to be updated. I would also like the tables and graphs to be saved as a picture so they can easily be inputed into presentations.

If we take the CTA spreadsheet as an example and the Tulip worksheet, I put new data on column A and B on a monthly basis I manualy put the column I too and then I want the column. What I would like is to have a worksheet data where I only have to put the last month data for each fund and the benchmark and for the individual graphs and table and the data in each worksheet to be updated.

I would like to have 2-3 extra worksheets to add new funds and for them to be integrated in the Piguet CTA and Piguet CTA G&T worksheets. If a fund is not updated (because it is not part of the selection anymore, it should be shown at a 0 weighting in the graph in Piguet CTA worksheet but the historical allocation should still be visible.

With regard to the weighting, I would like to have the weighting forward to be updated but also to be able to change it manually, if this could be done in the same additional worksheet where i would input the data monthly it would be great

I would like all the graphs and tables updated in the various worksheets and saved in separate pictures too (pictures i can input in various presentation

The same is required for the fixed income sheet

Skills: Data Entry, Data Processing, Excel, Visual Basic, Word

See more: how to run macro on multiple excel files, personal macro workbook, run macro on all sheets in workbook, how to share a macro enabled excel workbook, excel vba set workbook filename, excel macros, macro between two workbooks, run macro on multiple worksheets, excel macro open files, calculation sheets different excel files macro, excel macro open files directory, clean excel files macro, macro open files time excel, excel macro list worksheet names sheet, vba macro excel enable paste protected sheet, excel mkdir macro directory files, copy column data sheet macro excel, macro excel sheet input, excel macro web query cell sheet, excel macro create files

About the Employer:
( 0 reviews ) Mumbai, India

Project ID: #19289915

2 freelancers are bidding on average ₹5333 for this job


I am postgraduate (MBA) in finance with more than 5 years of experience in financial modeling, advanced excel, VBA automation and data processing. I have successfully completed similar projects, please have a look at m More

₹4000 INR in 1 day
(25 Reviews)

Hi, I am Monir and it will be my pleasure to assist you with this project. I have read your project description. You can expect from me I strong commitment to a deadline, the highest quality, and a fluid/friendly com More

₹6666 INR in 1 day
(7 Reviews)