Help
Im doing a daily report.
so there is a table with each day's date
eg: sept 1-30 ... so sheet 1 should have the date sept 1. sheet 2 should have sept 2
is there an easy way to do that? macros or formulas ? instead of having the trouble of writing the date to each sheet
|
Welcome
O'Reilly Answers is a community site for sharing knowledge, asking questions, and providing answers that brings together our customers, authors, editors, conference speakers, and Foo (Friends of O'Reilly). More »
Is there a way to automate worksheet names in Excel?1 Reply
Hi,
There is, the article that describes how to do this is on the Office site at Running a macro when Excel starts You can then add the code that renames and creates the sheets with the right names automatcally you open that work book. Regards, Alan |
|||
© 2012, O’Reilly Media, Inc. (707) 827-7019 (800) 889-8969 All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners. |
