How to get data from another sheet by matching multiple cells

Ref.attachment DATA.XLSX

Sheet1 has Symbols such as 20MICRONS etc (upto 2000 symbols).

In this sheet i need to get data for "OPEN, HIGH, LOW, CLOSE, LAST, PREVCLOSE, TOTTRDQTY, TOTALTRADES" for the date given above these headers - from sheet list-1, list-2 etc. (date is given in A1 cell of sheets list-1, list-2).

how to do this?

Please Login or Register  to view this content.

Originally Posted by JLGWhiz

Please Login or Register  to view this content.

i did not understand. i am not used to excel much. pls

That is a VBA macro.
1. If your Excel security settings allow you to accesss VBA, then save your workbook as a macro enabled workbook (.xlsm)
2. Open the vb editor by pressing and holding the Alt key while you press the F11 key. (Alt + F11)
3. If the code pane in the editor is dark, click 'Insert' on the tool bar, then click 'Module'
4. When the code pane is bright, copy the code from the thread above and paste it into the code pane.
5. Click save and close the vb editor.
6. You can run the macro from the Excel window by pressing Alt + F8, click the macro name, then click Run.

You only have to do steps 1 - 5 once. From then on you just do step 6 when you want to run the macro.

Originally Posted by JLGWhiz

That is a VBA macro.

Thanks a lot. It worked and solved.

You're welcome,
regards, JLG