You can only "pull" data in Excel with formulas, similar to what you are
doing to get your Sheet1 data over on to Sheet2. If you want to Copy and
Paste data from Sheet2 to Sheet3, just turn on the Macro Recorder and going
through the steps manually one time. Then turn off the Recorder and you got
a macro....sometimes it works straight off and sometimes it needs to be
tweaked.
Post back if you need more help.

Vaya con Dios,
Chuck, CABGx3




"sarah" wrote:

Hi, I have an excel sheet in which I pull data from another sheet using
VLOOKUP, as well as the =TODAY() functions. I hope to transfer the values
generated by these formulas into a table on a third sheet with the push of a
button.

This should help explain a bit of what I'm hoping for:
Sheet 1: Orders
Sheet 2: Shipping certificate (pulls data from !Sheet1)
Sheet 3: Takes data from !Sheet2 and puts it into table of shipped items.

Any help would be greatly appreciated, tips, hints, suggestions or links to
guides- thank you! (: