VBA Form - Allocate volume in a period to a new worksheet.

**macenmin** · 05-03-2013, 05:48 AM

Hi,

I have some difficulties to create a VBA form that will allocate/devide a volume in the number of months for an wanted period. The result sheet should present the volume pr row pr building/department/year and month. The result page has to be dynamic.

I attach a example workbook that explains my problem. I know how to build the form, but i'm not sure how to write the macros to do what I want to accomplish.

I hope anyone has time or willingness to see on this case. I would be very grateful for some tips/ideas or macros

Thanks in advance!

BR,
Macenmin

**Tinbendr** · 05-03-2013, 09:49 AM

See attachment.

I didn't understand about the volume. But maybe can can take it from here.

**macenmin** · 05-05-2013, 01:50 PM

Thanks :-)

What I mean with volume is that the user can register for example 3000 in this cell/inputfield. When data is being transferred/allocated to sheet 2, this Volume/value has to be splitted into the amount of months between the from and to date in sheet one - with one part of the volume/value in each row since each row represents one month for that department.

I dont know if this was so much clearer, hope so :-)

Thank you for your time and help so far :-)

Br,
Macenmin