| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying and transfering select rows of data
Hi
After 2 hours of trying and sifting through the discussion group I am beaten enough to ask for help... I have approx 1000 patient's data in a large spreadsheet recorded horizontally next to 'ID numbers' in column A. I have a separate list of 240 or so 'ID numbers', and I'd like them and all their data to be transfered from the main spreadsheet. I understand the macro has to run something like (for each of the 240 IDs) Find 'Patient ID' (in main spreedsheet) Select Row Copy row Activate Sheet 2 (blank spreadsheet) Paste Row I can program the last 3 steps but the first two I can't get to work properly... Any advice would be VERY much appreciated... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying data from one workbook to another dependent on user select | Excel Discussion (Misc queries) | |||
| can you select paste area before copying data | Excel Discussion (Misc queries) | |||
| How can i randomly select 780 rows from 4000 rows of data | Excel Worksheet Functions | |||
| Select certain data rows | New Users to Excel | |||
| select block of rows w/data between blank rows | Excel Programming | |||
Threaded Mode
