View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sarah Sarah is offline
external usenet poster
 
Posts: 231
Default Copy data into new line on seperate sheet?

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! (: