Copy paste loop and changing cells

[dafunkyfalcon]

Hi!

I'm looking for a way of creating a time series of values in certain cells that changes based on the date. I have one cell for year and one for month and by changing these, the values in H5:Q5 changes. I want to copy these values onto a new sheet in the right order. In other words, starting 1991-01 i want to copy the values in H5:Q5 onto a new sheet, then change to 1991-02 etc all the way through 2011-01.

Any suggestions?

Regards

 

[moonfish]

What I would do, is put the year and month values in columns and base your calculations on those values. Copy everything down across the sheet until you have every date up to 2011-01

Excel Workbook
	E	F	G	H	I	J	K
4	Ycount	YEAR	MONTH	Value1	Value2	Value3	..up to column Q
5	1991	1991	1	*	*	*	*
6	1991.083	1991	2	*	*	*	*
Sheet

 

[dafunkyfalcon]

Thanks a lot, I will try it out.

Does anyone else have any suggestions as how to do it in vba? I'm new to it so i would like to learn some.

Regards