| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
extracting data from columns to summary sheet
I have a worksheet with up to 60 names in col A, called AERIAL RESCUE
Each name is allocated 7 rows for different types of data entry. As below A J Q R7 20 R8 32 R9 33 R10 62 R11 38 R12 29 R13JONES 345 1 R14 56 R15 75 R16 95 R17 23 R18 43 R19 32 R20SMITH 26 6 I need to extract the data from Col J & Col Q to use in a summary sheet in the same workbook, called IND RESULTS. There could be up to 60 sets to extract and they fit in to the scheme below. Each Name on this sheet is allocated 36 Rows for their summary and the sheet contains all the summaries of all the names, one after the other. A ..D F R1 to R11 OTHER DATA R12 20 R13 32 R14 33 R15 62 R16 38 R17 29 R18 345 1 R19 to R36 OTHER DATA R37(next name and summaries in following 36 rows) I have tried all sorts of loops and ranges etc, but not getting anywhere at all. Can anyone please help ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generate sheet names from list, assign data to summary sheet. | Excel Programming | |||
| How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
| Extracting data from two columns | Excel Discussion (Misc queries) | |||
| Extracting data from other columns | Excel Worksheet Functions | |||
| Extracting data from one row across multiple columns | Excel Programming | |||
Threaded Mode
