Tia
There are a number of ways that data can be pulled/transferred from one
place to another. Tell us more about the nature of this data and the nature
of the transfer. For instance:
You want this to happen when the file is closed/saved, or when the data in
entered. There are conditions to the transfer, like, if this is true or if
this is bigger than that, etc. What about the destination? Is that always
the same row/column/sheet, or does that change by condition?
In short, pretend that you are instructing someone else to do this for you,
someone who doesn't know much about your work. What would you tell him?
HTH Otto
"Tia" wrote in message
...
I am working with 4 worksheets (1,2,3,4). I would like to pull/transfer
information from either worksheet 1 or 2, which ever one the data is
entered
into, to worksheets 3 and 4. Information will never be entered into both
worksheets (1 & 2) at the same time. I'm a novice in excel, so not sure
if
this is understandable. Let me know if further info is required.

Thanks!