| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying only selected data from Sheet 1 to Sheet 2
I have these data in Sheet 1
Cell A B C 3 112 John 3 159 Isaac 3 119 Paul 4 117 Joseph 4 114 Moses In my Sheet 2, I will have an allocated cell for my data entry, example I enter the number 3 When number 3 is entered, I want Row 5 to 6 in column A of Sheet 2 to extract Sheet 1 column A, B and C to appear all data of column A,B,C in Sheet 1. I tried lookup formula, but it is giving me the last information only that is if I entered 3, it will give me 3 119 Paul but I want to list down from John to Paul. Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying the repeated data of the previous sheet to the next sheet | Excel Discussion (Misc queries) | |||
| Copying Data from one sheet to another sheet on a specific day | Excel Worksheet Functions | |||
| Updating excel sheet with selected data from another sheet in the same file | Excel Worksheet Functions | |||
| Copying selected rows to another sheet | Excel Worksheet Functions | |||
| 2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions | |||
Threaded Mode
