CookieMonster76
Board Regular
- Joined
- Apr 30, 2015
- Messages
- 200
Hi
I have some data from a different tab, that I am copying into a summary. I need to mark which month is refers to, which I have done with this:
Range("C2:C" & Range("A" & Rows.Count).End(xlUp).Row).FormulaR1C1 = "Apr-2024"
I then need to copy in May data from a different tab, which i am able to do, but then mark it May-24 in Col C, but this needs to start one row after Apr ends (Offset?), but Apr-24 could be a varying length so the starting point for May can't be fixed.
Thanks in advance for any help
Paul
I have some data from a different tab, that I am copying into a summary. I need to mark which month is refers to, which I have done with this:
Range("C2:C" & Range("A" & Rows.Count).End(xlUp).Row).FormulaR1C1 = "Apr-2024"
I then need to copy in May data from a different tab, which i am able to do, but then mark it May-24 in Col C, but this needs to start one row after Apr ends (Offset?), but Apr-24 could be a varying length so the starting point for May can't be fixed.
Thanks in advance for any help
Paul