Paste rows based on parameter setting

[rowlandrat]

Hi,

I am trying to copy/paste a row a number of times depending on a specific paramenter.

For example, I have a list of rows on one sheet and a number of parameters on a second sheet. What I want to do is take each row in sheet 1 and paste it into sheet 3 the number of times the parameter is set to. Is this possible in Excel without using VBA?

To give an example

SHEET 1:
Task: Frequency: Owner:
Report: Daily: Mike
Issues: Weekly: Niall
Status: Monthly: Edel
Budget: Weekly: Tom

SHEET 2:
Weekly = 4
Daily = 20
Monthly = 1

SHEET 3:
I now want the Daily task to be repeated 20 times, the 2 Weekly tasks 4 times each and the Monthly task only once. The order is not important, just ensuring the repitition is what the parameter value is set to

Thanks