I need to have a cell in the main sheet of my workbook invoke a new - Microsoft Community

it simple but........

i have time sheet workbook.  columns days, rows time. 1 of rows mileage. want able type in mileage , have book create new sheet template have designed explain mileage text box notes. want have front sheet create hyperlink new template automatically , name sheet according date associated mileage entry dates on time sheet automated.

i aware information not  enough answer hope generate string me.

nino d.

hello,

this require vba , bit more question covers. if want write code yourself, may want @ many free vba resources , tutorials on web. chip pearson's site excellent. http://www.cpearson.com

if stuck specific aspect of code, come , ask question in context. 

Office / Excel / Windows 8 / Older versions