hi everyone, this is my first official help request post here, please be kind I'm not a newbie to excel, but i am a newbie to macros..

here is what i'd like to accomplish.

0. Row 1 is my header row and will be hard coded
1. Prompt user for # of rows, then multiply that by 3 and insert that number of rows (ie. if 2 is input, 6 rows would be added so rows 2-7 will be populated
2. Prompt user for column data.. there are going to be a few differences in the columns
- A2-Ax will always be the same for all rows
- B2-Bx will always be the same for all rows
- C2-C2+2 (3 rows as in C2, C3, C4) will have the same data, then C5-C5+2 (C5, C6, C7) will have the same data and so on
- D2 and D4 will be the same, D3 will be the same all the time, ie. D2, D4, D5, D7 will be the same.. D3, D6 will be the same
- E2-E2+2 (3 rows will aways have the same data.. ie E2=23, E3=22, E4=21, then it repeats E5=23, E6=22, E7=21 and so on
- F and G will be entered manually later on
- H will always be "Io"
- I will be like this.. I2 = A2&C2&"something", I3 = A3&C3&"somethingelse", I4 = A4&C4&"something", and it will continue for the number of rows by goin A5, A6 and so on..

if you need a visual diagram, i could add that too

thanks in advance!