move/copy data w

  • Thread starter Thread starter rc
  • Start date Start date
R

rc

Is it possible to set it so if i type a word in a
particular cell that the data that is in the corresponding
row is then moved to another sheet in the workbook?

For example: When I type the word Confirmed in Column X on
sheet1 I want the info from column c and k-aa on the row
that I just typed Confirmed for to copy over to sheet 2 in
cells A and B-R

For example: I type Confirmed in cell X9 on sheet one, I
want C9 and K9 - AA9 to move over to sheet 2.

Excel 2000
 
I think I'd take a slightly different approach.

I'd select my range and do Data|filter|autofilter.

Then I could use the dropdown in that column to show just the "confirmed"
values. After that, I'd copy the visible cells to the range. Then come back
and select those visible rows and rightclick|delete (entirerow).

You could have a macro do this (try recording one when you do it manually to get
the basic code), but this is a useful technique for lots of stuff. I'd want to
learn how to do it so it would help me in other workbooks.
 
Back
Top