C
Colin
I am working with a date range from Jan-Dec across 12 columns in a single
row. Underneath each month heading is say 5 or 6 rows of other data relating
to that month.
By using the date, year and month function I can start my range with any of
the months I choose say to show a financial year start and the rest of the
year will auto populate. How do I get the cells underneath the relevant month
to move to that month when I change the start month.
eg months in A1-L1, other data in A2-L5. Financial year start in March so A1
is March and Jan moves to K1. Move the data originally in Col A relating to
Jan to Col K?
Sorry if this sounds quite basic but I have only just got into functions and
can't find this on help.
row. Underneath each month heading is say 5 or 6 rows of other data relating
to that month.
By using the date, year and month function I can start my range with any of
the months I choose say to show a financial year start and the rest of the
year will auto populate. How do I get the cells underneath the relevant month
to move to that month when I change the start month.
eg months in A1-L1, other data in A2-L5. Financial year start in March so A1
is March and Jan moves to K1. Move the data originally in Col A relating to
Jan to Col K?
Sorry if this sounds quite basic but I have only just got into functions and
can't find this on help.