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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

automatically pasting cell into different sheets? 1
Auto data entry 2
Very strange behaviour of VLOOKUP in Excel 2010 4
Average Question 2
Data Validation and drop-down list using IF, AND and what else? 8
Blank Cells 3
if the numbers in sequence 11
Building closed workbook file path within an Index Function 6

Back
Top