Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If found, then copy and paste contents, otherwise move on
Yeah, it makes sense.
But it also makes sense to apply the filter and copy all the rows that match in one fell swoop to its new location. (well, it does to me.) Annette wrote: Well ... all I want to have to do is paste raw data into the sheet, and run a macro so that it carries to the master so that it will link into another existing spreadsheet. Does that make sense? So the filter won't work. "Dave Peterson" wrote in message ... How about applying Data|filter|autofilter, then filter (custom?) for what you want. Then copy those visible cells and paste them where you want them. Annette wrote: I want to be able to find data that varies each month but I am able to provide a standard. What I need the macro to do is look at the raw data found on sheet 1 and if the characters DRP1 (for example) are found in a cell in column 1, then copy the three ajacent cells to the right and paste into the master sheet next to DRP1, else nothing. For example: (raw data) DRPA 148 761 333 1,242 DRPI 41 54 12 107 (master sheet) DRPA 148 761 333 DRPB (nothing) DRPC (nothing) DRPI 41 54 12 I hope this makes sense as I have over 1,000 to loop through. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can user move in locked worksheet but not copy cell contents? | Excel Worksheet Functions | |||
copy paste delete cell contents | Excel Discussion (Misc queries) | |||
Cut and paste or Copy just cell contents? | Excel Discussion (Misc queries) | |||
Copy contents in a row and paste in a column | Setting up and Configuration of Excel | |||
Move C5 to C10 in Excell (no cut/ copy/ paste)? | Excel Discussion (Misc queries) |