View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Den Den is offline
external usenet poster
 
Posts: 3
Default new day in next worksheet Day 1 plus 1?

add the value to a date in 1st worksheet to the value in the date in the new
work sheet.
using a macro function
I would like to add a new worksheet and use the date value in the previous
sheet with an increment of 1.
So make worksheet with sunday jan 1 in cell a1 and add a new worksheet so
monday jan 2 is in cell a1 wksht 2.

make newsheet (lastsheet(a1)+1) ???????