winxmun
07-29-2009, 04:43 AM
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:
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: