Excel worksheet

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hi, I am trying to find a way to text from Sheet1 onto sheet2...the
situation is as follows...Sheet1 is a menu and each row has in a cell an
item, an amount and a price.
each row calculates the totals.
Is it possible to copy only the row of cells I pick on to sheet 2 by
clicking that row?
I tryed everything I could think of so far not even close...Cut and
paste was my only means, Thank you for any help you can offer.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **
 
Copy and paste wasn't sufficient?

Maybe you could use a column to mark your choices. Then apply
data|filter|autofilter and show only those rows.

Then copy those visible cells to the other sheet.
 
This method occurred to me (as yet with little or no refinement!!)
Enter a character in an empty cell on Sheet1 (I used a full-stop) and the
first 6 columns will be copied to Sheet2.

Private Sub worksheet_Change(ByVal Target As Range)
Range(Cells(Selection.Row, 1), Cells(Selection.Row, 6)).Copy
Sheets(2).Activate
Do
If IsEmpty(ActiveCell) = False Then
ActiveCell.Offset(1, 0).Select
End If
Loop Until IsEmpty(ActiveCell) = True
ActiveCell.PasteSpecial
Application.CutCopyMode=False
End Sub
 
Back
Top