View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ola2B Ola2B is offline
external usenet poster
 
Posts: 32
Default Generating report with VBA

I have 3 workbooks with each containing at least 7 worksheets. Clients
signs off their reports once updated i.e. their name in cell B2 of
each worksheet. The problem is currently I find difficult to
establshed who has updated the reports without going into individual
sheet. Can someone help me put together a vb code that generates a
report on which sheet(s) are updated a update and which are not.
Please bote that the sheets name are held in a separate workbook,
range a2:a50.

Many thanks