is this possible?

  • Thread starter Thread starter compitus
  • Start date Start date
C

compitus

Hi! I am trying to get Excel to copy content of some cells to next sheets,
depending on the number I put in last cell. IE A1:A3 have some text. Now, if
I put number (2,3,4 or 5) in A4, I wanted to copy A1:A4 to Sheets 2,3,4 or5,
depending which number I put in A4 (if 2, then to Sheet s, if 3 to Sheets 2
and 3 and so on).
Is this doable in Excel or should I use Visual Basic or some other program?
Thank You for help
 
First, Is this possible is not a very descriptive question. Many won't
bother to look and it doesn't do much for archives for those who follow with
similar problems.

You could do this with some elaborate formulas but it would be much better
to use a worksheet_change event to make it automatic.

Suggest your re-post
 
Back
Top