Dynamic list population base don specific criterium

cbeck,

I do not have a complete solution to your need, partly because I am not completely sure what it is you want. Are you looking for a button that when you push it, it reads in the number of months on the MediaBuy tab and posts the name of the Publisher/Source into the Data-Usage tab a number of times equal to the number of months?

I can make one specific improvement to the MediBuy tab. In Cell E3, enter the following formula and drag down:

=YEAR(D3)-YEAR(C3))*12+MONTH(D3)-MONTH(C3)+1

This formula calculates the exact number of months. Your current formula is returning a decimal number of months, which only appearS like an integer of months because you are not showing the decimals. The above formula I have given is helpful, because any macro you seek that fills in the data in the Data-Usage tab needs integer values. For example, you want to fill in exactly 12 rows with the word "Monster". It would not make sense to fill in 12.1 rows.

Hope this helps.
______________________
[1] If this reply was helpful, click the star to the left.
[2] If this reply answered your question, mark this thread as [SOLVED].