andrewb90
Well-known Member
- Joined
- Dec 16, 2009
- Messages
- 1,077
Hello all,
I've been trying to look at similar code to try to put together what I want, and I'm still struggling to get it right, so I figured maybe somebody on here could help me out.
I am trying to copy the values of multiple cells in a single row to a different sheet. The trick with that is the row that I am going to copy depends on which row has a value in F.
So starting with F16 if the cell isn't blank, then G16, I16, & M16 will have their values copied to "Sheet4" B5, B6, & B7. (There are a few more cells, but to simplify things, I just put three.
Now if F16 is blank, we move to F17, then F18, and the formulas will follow, except they are going to the exact same cells on Sheet4. They will always stay the same.
To make things trickier, there will be values in some of the F Column,so I only want to copy data from the last row thats been used within my specified range. (F16:F22, F26:F32, F36:F42, F46:F52)
These rows are all days with the top row being the beginning of the month and the bottom being the end. Numbers should get added in every day, so the third day this runs, it should be looking at the data from row 19.
Hopefully I'm not too confusing:
Any suggestions or help would be wonderful. I'm always open to perhaps an easier way to do what I need
I've been trying to look at similar code to try to put together what I want, and I'm still struggling to get it right, so I figured maybe somebody on here could help me out.
I am trying to copy the values of multiple cells in a single row to a different sheet. The trick with that is the row that I am going to copy depends on which row has a value in F.
So starting with F16 if the cell isn't blank, then G16, I16, & M16 will have their values copied to "Sheet4" B5, B6, & B7. (There are a few more cells, but to simplify things, I just put three.
Now if F16 is blank, we move to F17, then F18, and the formulas will follow, except they are going to the exact same cells on Sheet4. They will always stay the same.
To make things trickier, there will be values in some of the F Column,so I only want to copy data from the last row thats been used within my specified range. (F16:F22, F26:F32, F36:F42, F46:F52)
These rows are all days with the top row being the beginning of the month and the bottom being the end. Numbers should get added in every day, so the third day this runs, it should be looking at the data from row 19.
Hopefully I'm not too confusing:
Any suggestions or help would be wonderful. I'm always open to perhaps an easier way to do what I need
Last edited:
