Solved: How to auto populate data from Worksheet

[winxmun]

How to extract/ link data from Sheet1 to Sheet2 whenever user input cell B1 & C1? :help

Eg. If user input 1Q/07 at B1, Excel to auto search 1Q/07 from Sheet1 & auto populates the data (Item 1 – Item 8). Likewise for C1.

Pls refer to sample file attached. tks a lot! :cloud9:

[mdmackillop]

Try this

=HLOOKUP(Sheet2!B$1,Sheet1!$1:$10,ROW()-1,FALSE)

[winxmun]

Yes! It works perfectly! Thank you so much...:friends: