View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Heera Chavan[_2_] Heera Chavan[_2_] is offline
external usenet poster
 
Posts: 18
Default Add new sheet automatically every data.

Hi all,

I have four users and everyone update some information in a sheet and runs a
macro to update that information in a centerlized database sheet.

Now my problem is every day i have to add a new-sheet (Sheet Name is Todays
Date) manually in the database sheet which i want to avoid.

I dont know how to write a code which will detect todays date sheet if it is
not there it should create it automatically. I just to add this code in my
macro.

Regards
Heera