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. 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. Then I resort the group of cells and erase the 5 that I copied in so that it is ready to repeat. 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). I have set up the structure for what I need and then recorded a macro for the first iteration. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |