Macro on excel files -- 2

Ditutup Dipasang 4 tahun yang lalu Dibayar saat pengiriman
Ditutup Dibayar saat pengiriman

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

Entri Data Pemrosesan Data Excel Visual Basic Word

ID Proyek: #19289915

Tentang proyek

2 proposal Proyek online Aktif 4 tahun yang lalu

2 freelancer rata-rata menawar ₹5333 untuk pekerjaan ini

bhupendrayadav

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 Lebih banyak

₹4000 INR dalam 1 hari
(25 Ulasan)
4.4
Monirulop

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 Lebih banyak

₹6666 INR dalam 1 hari
(7 Ulasan)
3.4