macro to paste data in smaller time increments

[Runner23]

i need to make a macro that looks at data in, say quarterly intervals, and then will paste it on a monthly or weekly basis.

can anyone help w this

 

[villy]

Can you make your question clear please...?
Thanks

 

[Runner23]

ok, i have some formulaes that pulls in data that is sometimes monthly, sometimes quarterly.

Since i need to compare this with other data which is mostly weekly or daily, i need an equal amount of data points.

So, if i get quarterly data for instance, can i get a macro that pastes the same quarterly for every week, until there is a new quarterly data point.

 

[villy]

I think it is possible specially when you include a sample sheet. For others also to understand clearly what you really want then you'll get your answer.

 

[Runner23]

the thing is I use multiple types of data that is available in varying frequencies. Some daily, some weekly, some monthly, some quarterly.

Since i compare these types of data i need an equal amount of datapoints.
So when i want to compare data that is daily with data that is monthly, i need to paste 29 extra datapoints(assuming a 30 day month), so theres an equal amount of datapoints as with the data that is daily.

 

[Runner23]

the thing is I use multiple types of data that is available in varying frequencies. Some daily, some weekly, some monthly, some quarterly.

Since i compare these types of data i need an equal amount of datapoints.
So when i want to compare data that is daily with data that is monthly, i need to paste 29 extra datapoints(assuming a 30 day month), so theres an equal amount of datapoints as with the data that is daily.

anyone can help with a macro for this??