ST Alpha - "Because ST is super smart .......Excel Help needed.." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 150

Because ST is super smart .......Excel Help needed..

Posted by Walt_Disney (aka Walt_Disney) Nov 5 '09, 07:51

From a co-worker

"How can you put dates into the tabs of an excel worksheet without having to type each individual date. For example, in week one of February I need Feb 1, Feb 2, Feb 3, Feb 4, Feb 5 in consecutive tabs. How can I get excel to update the tabs for me?"

Responses:

just name the tabs with the day numbers and change the name of the workbook to suit the month as each new month comes up -- nm - zork Nov 5, 08:09
It's easier to just type the tabs, isn't it? -- nm - Jim Nov 5, 07:56
They would need to write a macro to do it -- nm - decline Nov 5, 07:56
I've done this but it required a bit of programming. Or the usual copy and paste with manual update of the 1 2 3 4 5 where necessary -- nm - lone canadian leafs fan Nov 5, 07:53
like a "fill series" type of thing for the tab names? nu uh, unless you do it in VBA -- nm - zork Nov 5, 07:53
The tabs are the names of the worksheets? Suck it up and type them -- nm - Roger More Nov 5, 07:53

Post a message top

Because ST is super smart .......Excel Help needed..

Replies are disabled on threads older than 7 days.