Create Entries on another sheet based on frequencies

[catnam]

I need help in making this workbook create transactions for the year based on the Frequencies listed. For example, because Bank of America Dividend Income is due/paid Weekly, it should appear 52 times starting with the First Due Date, and every week after (Jan 9, Jan 16, Jan 23, Jan 30, Feb 6, and so on). Based on current setting in grid at left, (see Expected Results sheet) this is what I need help in getting to show up on the "Budget Entries" sheet, columns in the order shown (Original Sequence column info only). If all 8 rows had frequency of Weekly, there would be (8x 52=) 416 entries on on the Budget Entries sheet, so code or formulas need to be flexible to accommodate change number of entries.
Thanks very much for any help.

[JBeaucaire]

Woo... that was not as small a task as I first envisioned. There is some hidden traps here with each data type, so hopefully this gives you what you want AND takes care of those off years where December has more pay weeks than normal, Weekly and Bi-Weekly specifically at issue.

Please Login or Register  to view this content.

[catnam]

Thanks you so much for your help. I inserted a module in my workbook and pasted your code inside, then created a command button and assigned to it the code. However, I get a 'script out of range' error when I click the button.

[xladept]

Hi Catnam,

Try this:

Please Login or Register  to view this content.

[JBeaucaire]

Yes, I had that problem, too. Your sheet name has a hidden space at the end, take that out.

"Budget Input UI "

[catnam]

The code works great! Thanks so so much. I have just one little issue. While all the data post just the way I want, I get a Run-time error "1004': "The sort reference is not valid. Make sure that it's within the data you want to sort, and the first Sort by Box isn't the same or blank. What do that mean?

[catnam]

Thanks so much, it worked just fine. Also thanks for adding the dollar signs. Sweet!!!

[catnam]

Thanks. I fixed that, now it works great.

[JBeaucaire]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[catnam]

Got it done. Thanks again.