Copy data into new line on seperate sheet?

S

sarah

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! :)
 
C

CLR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need macros for copy data into new workbooks 2
Data in sheet1 to be put into sheets 2, 3, 4, 5, etc 2
Copy data into another worksheet and have it update automatically? 10
Subset of table data on another worksheet 1
exitsing table copying into new workbook 2
Copy data into another worksheet and have it update automatically? 4
Combine columns from seperate sheets into new sheet- macro improve 4
exporting/linking data from a row on one sheet into another sheet 1

Top