Hi all
I consider myself an intermediate Excel user as far as formulas go, but a total rookie with macros and vba so I appreciate any help you can give. I'm using a Mac with OSX and Excel 2004.
I have set up the structure for what I need and then recorded a macro for the first iteration. I am copying a range of 5 cells from one column (starting with B3-7) to another (always H3-7), then sorting them in with some other numbers that are in the same column (H8-1180), grabbing the result of a formula from one cell (K1) and pasting the value of it in a final place (M7 etc). Then I resort the group of cells and erase the 5 that I copied in so that it is ready to repeat.
What I need is the code for a loop that will go down one cell from where it started before and copy the next five cells (four that are the same and one new one), bring them over like before and when I grab the result of the formula I need to paste it one cell lower than I did previously.
I have one cell (E1) that contains the count of the column where I am grabbing the data from so I assume that can be used in the for loop as in for count = 1 to value of E1.
Thanks for any help
Maureen
I consider myself an intermediate Excel user as far as formulas go, but a total rookie with macros and vba so I appreciate any help you can give. I'm using a Mac with OSX and Excel 2004.
I have set up the structure for what I need and then recorded a macro for the first iteration. I am copying a range of 5 cells from one column (starting with B3-7) to another (always H3-7), then sorting them in with some other numbers that are in the same column (H8-1180), grabbing the result of a formula from one cell (K1) and pasting the value of it in a final place (M7 etc). Then I resort the group of cells and erase the 5 that I copied in so that it is ready to repeat.
What I need is the code for a loop that will go down one cell from where it started before and copy the next five cells (four that are the same and one new one), bring them over like before and when I grab the result of the formula I need to paste it one cell lower than I did previously.
I have one cell (E1) that contains the count of the column where I am grabbing the data from so I assume that can be used in the for loop as in for count = 1 to value of E1.
Thanks for any help
Maureen