Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and Append Macro
nI'm searching for information to copy data from one worksheet and append it
into another based on information within a specific cell (roll): Example Search row "H" if data ="HJK" copy and append to worksheet="new data" All of the new data will go into the same new worksheet. I'd appreciate any help and directions where I can find the information. Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and Append Macro
See Ron de Bruin's site for copying to next available row on another sheet.
http://www.rondebruin.nl/copy1.htm If not suitable see his Copy/Paste/Merge examples. http://www.rondebruin.nl/tips.htm Gord Dibben MS Excel MVP On Fri, 4 Apr 2008 10:35:00 -0700, Excel Help! wrote: nI'm searching for information to copy data from one worksheet and append it into another based on information within a specific cell (roll): Example Search row "H" if data ="HJK" copy and append to worksheet="new data" All of the new data will go into the same new worksheet. I'd appreciate any help and directions where I can find the information. Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and Append Macro
Thanks this is great! I have two additonal questions if I may; Can I have it
to prompt me for the criteria; or add the "or" option for more then one criteria; example criteria1="=" 234" or criteria1=" 567". I can add addtional criterias by adding criteria2. However, this read as 1 and 2. I'd like 1 or 2. Thanks again "Gord Dibben" wrote: See Ron de Bruin's site for copying to next available row on another sheet. http://www.rondebruin.nl/copy1.htm If not suitable see his Copy/Paste/Merge examples. http://www.rondebruin.nl/tips.htm Gord Dibben MS Excel MVP On Fri, 4 Apr 2008 10:35:00 -0700, Excel Help! wrote: nI'm searching for information to copy data from one worksheet and append it into another based on information within a specific cell (roll): Example Search row "H" if data ="HJK" copy and append to worksheet="new data" All of the new data will go into the same new worksheet. I'd appreciate any help and directions where I can find the information. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you append one row to another? | Excel Worksheet Functions | |||
Find and append | Excel Discussion (Misc queries) | |||
Macro that will Cut rows and then insert-copy or append | Excel Discussion (Misc queries) | |||
How do I create an excel macro to append to a cell with existing i | Excel Discussion (Misc queries) | |||
Hotkey problem w/ macro to append comment | Excel Discussion (Misc queries) |