Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Values with VBA
Hello everyone, I would like to run a Macro that each time I do (by the way,
it will be used for printing and registering), right now I have this: ------------------------------------ Sub Print_Register() ' ' Keyboard Shortcut: Ctrl+Shift+P ' Sheets("PRINT FORM").Select ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1, Copies:=1 End Sub ------------------------------------- To add a code that will copy certain values from "Sheet A" that acts as a form (some of these values are =today() and vlookups and so on, so I need to paste "As Value") into "Sheet B" that should act in a list-kind-of-way. I need: "Sheet A" to take K2 and put it into "Sheet B" A2 "Sheet A" to take K12 and put it into "Sheet B" B2 "Sheet A" to take E2 and put it into "Sheet B" C2 "Sheet A" to take M50 and put it into "Sheet B" D2 .... and so on... and next time I run the macro to copy those values from Sheet A but now to insert them into Row 3, then Row 4, then Row 5, and so on... (or if it is possible to keep the last-entries-first-in-the-list order and so on that is even better!) any ideas? ,thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Values with VBA
Thanks Don!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy graphs values in a cell | Charts and Charting in Excel | |||
how to get rid of " " when copy values? | Excel Discussion (Misc queries) | |||
Copy VLookup Values | Excel Worksheet Functions | |||
How to copy values in various rows automatically | Excel Discussion (Misc queries) | |||
How do I copy only sub-totalled values - without any detail? | Excel Worksheet Functions |