If & Macro

[rjacmuto32]

I have a file with several tabs that I have macros to change data and format data and I trying to add one more thing but don't know how or where to do it. Below is my excel workbook code that I used the free program to convert your sheet to put into this message. I'm not looking for anything fancy, just plain and simple. Being new to these types of statements I've tried some websites to learn different things but I'm stuck at this:

I have 3 ranges with data B7:D9, B12:D14, B17:D19 while column A has the number 1,2,3 on row 7,12,17. I want to do something where whatever number I put in say cell H14 it will copy the corresponding range and paste it into I9:K11

Ex. Cell H14 has the number 2, so I would want to copy the range B12:D14 and paste that into cells I9:K11

Book1
	A	B	C	D	E	F	G	H	I	J	K
1
2
3
4
5
6
7	1	Actuals	AltBudget	AltBudget
8		Year2005	Year2005	Year2005
9		Jan	Feb	March
10
11
12	2	Actuals	Actuals	AltBudget
13		Year2005	Year2005	Year2005
14		Jan	Feb	March				1
15
16
17	3	Actuals	Actuals	Actuals
Sheet1

 

[al_b_cnu]

Hi Yogi,

I dont know WHERE I got that fomula from, I meant =OFFSET($A$1,$H$14*5+ROW()-8,COLUMN()-8)