Diana has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Excel VBA
HI,
I am stuck with a problem, hope you can help me.
I need to create front sheet where I will keep total nomination volumes from different companies and I need to create a marco that will take this total volume and upload it in the cells in sheet 2 but there value needs to be divided by numbers of days in any given month. I am a little stuck on what is the best solution is for this.
many thanks
Diana
RE: Excel VBA
Hi Diana,
Thank you for the forum question.
I have created a dummy workbook where I have done the coding.
Please have a look at the attached workbook and tell me if it make sense.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
RE: Excel VBA
HI Jens,
thank you for your response. unfortunately couldn't see any coding, just some data in the spread sheet.
front sheet data looks similar to what I had in mind, destination however, I would use columns B and onwards as counterparties and use rows in column A to have dates ( 1st-31Jan for example) and for A LTD daily volume would be 67390.26 ( total volume/31 days)
hope that helps
many thanks
Diana
RE: Excel VBA
Hi Diana,
I hope that I understand what you want.
I have amended the code in the attached workbook.
Please open the workbook. Have a look at the sheet destination. Then open the visual basic editor and execute the code.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
RE: Excel VBA
Hi Diana,
The code in module 2 is just some tests I did. The code in module 1 is the code to do the job.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
