what is the formular to use from one wokesheet to a new workbook
 

I WOULD LIKE THE FORMULAR TO USE SO THAT WHEN I ENTER AN AMOUNT IN ONE
WORKBOOK IT WILL GO TO ANOTHER WORKSHEETBUT TO A DIFFERENT CELL EACH TIME

what is the formular to use from one wokesheet to a new workbook
 

How does it know which cell?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"CONNIE" wrote in message
...
I WOULD LIKE THE FORMULAR TO USE SO THAT WHEN I ENTER AN AMOUNT IN ONE
WORKBOOK IT WILL GO TO ANOTHER WORKSHEETBUT TO A DIFFERENT CELL EACH TIME