How to easily populate a row for just one month

**Gary910** · 04-12-2014, 12:08 PM

I want to be able to have 12 sheets (for each month respectively) and have it populate one row with all days of that month. I can do it manually, but was wondering if there is a way to automate it. It is a spreadsheet I create every year (a calendar of sorts) for time tracking. I would also like to be able to highlight (i.e. Saturdays).

This probably will require some VB. (My knowledge of VB is just a smidgeon above nil.)

**elayaz** · 04-12-2014, 12:42 PM

Hi,

Something like this will help?

http://office.microsoft.com/en-us/te...010269598.aspx

**Richard Buttrey** · 04-12-2014, 01:37 PM

Hi,

Before going too far consider whether you really need a sheet for each month. If you are entering original data you'll be better advised to enter all data on a single sheet so that you have a proper database which you can use for subsequent analysis.

**bebo021999** · 04-12-2014, 02:27 PM

With first sheet named "Jan"

B1:AF1 is days across

B1=DATEVALUE(1&"/"&MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)&"/2014")

(Replace "/2014" with "/"&year(today()) if you wish to apply current year)

C1=IF(OR(B1="",B1=EOMONTH($B$1,0)),"",B1+1)

Drag across to AF1

Right-click on sheet name "Jan", choose Copy to a new sheet. name it "Feb" (and Mar, Apr,...Dec with "mmm" format)

Condition format for Sat (as file attached)

Hope this helps!