| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Data
I have VB code that creates the data below by using subtotals but I need to
find data in column A (7760) and copy and paste the data in another tab (Schedule Counts). In other words, search for '7760' in column A and cut and paste the row where '7760' exists. In the example below, I need to copy and paste A2:C4. I appreciate any help. Column A Column B Column C 1) 7750 6:00am 11 2) 7760 6:00am 9 3) 7760 6:15am 13 4) 7760 6:45am 4 5) 7765 7:00am 6 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find, Match data and paste data between two workbooks | Excel Discussion (Misc queries) | |||
| Find formatting doesn't work: "Excel cannot find data" | Excel Discussion (Misc queries) | |||
| Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
| The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) | |||
| FIND DATA WITHIN DATA (V-OR-H LOOKUP/FIND/MATCH?) | Excel Worksheet Functions | |||
Threaded Mode
