Hey! thank you soo much! It works beautifully!!! heee eheee
I ended up writing it like this:
Sub copytobiz()
'
' copytobiz Macro
' Macro recorded 1/27/2004 by Barbara Sorensen
'
' Keyboard Shortcut: Option+Cmd+g
Selection.Copy
Windows("Biz2004.xls").Activate
Sheets("DOME").Select
Cells(Rows.Count, "I").End(xlUp)(2).Select
If ActiveCell.Row = 2 Then
If IsEmpty(Range("I1")) Then Range("I1").Select
End If
ActiveSheet.Paste
End Sub



Now......as I was playing with this, it came to mind that I might like
to make this automatic......
(I know, hindsight is awesome...)
i.e.
every time I enter a number that is 600 or greater in column E, and
greater than 0$ in column F, that I'd like it to automatically kick in
without me having to push command - option-g. How can I do that?
And...also, if I later change the amount or number in the first
worksheet, I woudl like it to automatically change the amount or number
int eh second sheet as well. I'm guessing it has something to do with
if/then and sort? Can an excell sheet be made to trigger automatically
like that? or am I asking for greater trouble down the line?

thanks
Barb


---
Message posted from http://www.ExcelForum.com/