copy when the date is entered

  • Thread starter Thread starter Beesht
  • Start date Start date
B

Beesht

I have 12 sheets (months of the year) what I would like to be able to d
is copy a row of data, say from Jan to Jul automatically when I enter
date in the date collumn it also sends a copy into Jul.
I have an excel book but can not find anything about this.
Any ideas welcome.
Thank
 
beesht,

You will need to write some code in the worksheet_change
event for each worksheet (possible only a pointer to a
subroutine passing parameters) which tests which cell is
being changed, and if the one you wnat, the do the copy
you want.

Steve
 
Back
Top