pinkcookie
New Member
- Joined
- Mar 23, 2016
- Messages
- 4
I'm trying to write a VBA code that shifts the data of a cell based on the start month, so for example:
I want to make it such that if I change the start month to, let's say June, then the data will shift 3 cells to the right.
I've tried using offset and match functions on excel and I tried coding it in vba but I'm having no luck.
Sorry if the formating for this question is weird, it's my first time posting for excel help!
- if the start month is March then the "data" set starts in March (and there's a 12 month table, starting from Jan. to Dec., each month is a column, the start month will be indicated as a text/string before the 12 columns, on the same row)
I want to make it such that if I change the start month to, let's say June, then the data will shift 3 cells to the right.
I've tried using offset and match functions on excel and I tried coding it in vba but I'm having no luck.
Sorry if the formating for this question is weird, it's my first time posting for excel help!