Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying and moving column contents along with headings
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. -- Colin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying changed pivot report headings | Excel Discussion (Misc queries) | |||
How do I lock the top 2 rows (headings) so that they are always displayed when moving around the spreadsheet? | Excel Discussion (Misc queries) | |||
moving the contents of a cell | Excel Worksheet Functions | |||
Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions | |||
Copying the contents of a column into a chart | Excel Worksheet Functions |