Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I create a formula to copy and paste between workbooks?
I would be grateful for any help with this. I am trying to scan one column
on a worksheet for a name e.g. Smith and then to copy all the information on the same row into another workbook. There would be many rows with the name Smith in that column and would like ALL of these rows to be copied into the other workbook. I saw the information posted by Bob Phillips on 10 Jan about programming excel to do this but I do not understand how the formula would actually look. Thanks a lot. |
#2
|
|||
|
|||
Easiest way is to put an autofilter on the top of the row heading:
DataFilterAutofilter: then choose the name you want - then copy - paste. Otherwise use a pivot table of the data area "NickyHarris69" wrote: I would be grateful for any help with this. I am trying to scan one column on a worksheet for a name e.g. Smith and then to copy all the information on the same row into another workbook. There would be many rows with the name Smith in that column and would like ALL of these rows to be copied into the other workbook. I saw the information posted by Bob Phillips on 10 Jan about programming excel to do this but I do not understand how the formula would actually look. Thanks a lot. |
#3
|
|||
|
|||
Phil
Thanks for your reply. Unfortunately I am not permitted to change the order of the rows, even temporarily. I was searching for an automated scan which then copies and pastes the information as a result of the scan. Thanks once again. -- Nicky "Phil Wales" wrote: Easiest way is to put an autofilter on the top of the row heading: DataFilterAutofilter: then choose the name you want - then copy - paste. Otherwise use a pivot table of the data area "NickyHarris69" wrote: I would be grateful for any help with this. I am trying to scan one column on a worksheet for a name e.g. Smith and then to copy all the information on the same row into another workbook. There would be many rows with the name Smith in that column and would like ALL of these rows to be copied into the other workbook. I saw the information posted by Bob Phillips on 10 Jan about programming excel to do this but I do not understand how the formula would actually look. Thanks a lot. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Copy Paste of Formula Produces Incorrect Result | Excel Discussion (Misc queries) | |||
How to copy cells with keeping exact formula intact | Excel Discussion (Misc queries) | |||
Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) | |||
Copy and Paste Formula Without the linked file path | Excel Worksheet Functions |