Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! (: |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy data into new line on seperate sheet?
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! (: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
flowing data to seperate sheet | Excel Discussion (Misc queries) | |||
How to copy variable data from 2 worksheets into a seperate 3rdworksheet | Excel Worksheet Functions | |||
To copy the formula in one cell to another in a seperate sheet | Excel Discussion (Misc queries) | |||
Does anyone know how I can seperate a post code in my data sheet? | Excel Discussion (Misc queries) | |||
Print data in each row on a seperate sheet template | Excel Discussion (Misc queries) |