View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JAF JAF is offline
external usenet poster
 
Posts: 4
Default 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!