Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy entire row from another sheet onto first sheet if a unique text matches
https://www.dropbox.com/s/f83y17dedajbsz8/example.xls
There is an example workbook for what I want to do. There is the first sheet, which I basically use to put copy the data from the other sheets onto sheet 1 (Main). The other sheets have all the data I am concerned with, and each row has a unique code (e.g. Fruit01, Pie01, Juice01 etc.). What I want to be able to do is TYPE in the unique code into any cell on column D of sheet 1. If the code typed matches any of the existing codes in any of the sheets available, then that entire row will be copied onto sheet 1. Being able to copy the £ sign isn't important, as I forgot that I won't actually have any special symbols on my actual worksheet I'm trying to get this on. Hope that makes sense. |
#2
|
|||
|
|||
Quote:
Not sure if this helps but see my slightly rework example. Note it has been converted to 2010.xlsx hopefully you are able to use. Regards, Gizzmo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy from sheet to sheet when matches criteria | Excel Worksheet Functions | |||
Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet. | Excel Programming | |||
ID unique text and copy to another sheet within workbook | Excel Discussion (Misc queries) | |||
Copy Entire Sheet | Excel Discussion (Misc queries) | |||
Copy the entire sheet to overlay existing sheet? | New Users to Excel |