rjacmuto32
Board Regular
- Joined
- Jul 14, 2004
- Messages
- 98
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
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 |