View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Auto enter current date in cell when another changed

What works great?

To whom or what are you responding?

Post some of the original posting or a message ID


Gord Dibben MS Excel MVP

On Wed, 24 Jun 2009 19:12:43 +0100, sbird
wrote:


This works great! I'm a complete novice at VB and macros. How can I
make it work for a number of column pairs in a spreadsheet? In addition
to entering the date in column B when column A is updated, I need to
update column D when column C is updated, and so on. Ultimately, I'll
need this about 9 times across my spreadsheet. Thanks.