Populating columns based on Month/Year

[sykinc]

Hi All - Is it possible to enter a month and year on one sheet, say, April 2014, and then on another sheet, only 4 columns are populated (Jan, Feb, March, April) with a 5th column saying 2014? Basically, I don't want 8 blank columns before 2014 shows up, just the 4 months + 1 column for year, based on input. But, the trick is it needs to be flexible if a different month is input. Thanks for any help!

 

[JB_Scotland]

With Sheet1 enter your date, say Apr 2014, in Cell A1 and custom format "mmm yyyy".

On Sheet2 enter the formula =DATE(YEAR(Sheet1!$A$1),MONTH(Sheet1!$A$1)-4+COLUMN(A$1),1) in cell A1 and drag copy across your five columns.

Custom format Cells A1 to D1 as "mmm" and Cell E1 as "yyyy"

 

[sykinc]

Thanks for the response! Is it possible to set this up so it automatically populates the columns on the second sheet? I do not want to have to drag/copy/reformat every time I enter a date on the first sheet. Trying to find a way to automatically do this no matter what date I put in - and on the second sheet the correct number of columns always is generated. Thanks for the help!

 

[JB_Scotland]

Not sure quite what you want to achieve as the solution I suggested is dynamic? You can change the date in A1 and Sheet2 headers in row 1 will change.

If you have other data on Sheet1, say sales in columns by month, and that needs to be shown on Sheet2 for say a summary for the last quarter, there are certainly ways of doing that. You need to clarify the full extent of your problem.