please help me to right a macro where differene of two dates will be months and that month will use to divide the no of days in second sheet and than those divided days will fill in cells from start date and ends with end date - eg
Sheet one - Start date - 01/01/2014, end date - 01/02/2014
Sheet two - no of days - 20
Sheet three - Months are in columsn from Jan'14 - Dec'14
Results - there are two months so 20/2 - 10 and value will enter 10 in Jan and 10 in Feb.... where its on month - it will be one entery.
Please suggest
Bookmarks