View data from a specified sheet according to the conditions

[aabonargis]

Hi
I have an excel workbook that contains a set of sheets
main sheet (basmaa) that displays data from other
I use the Index function to display the data from the sheets (Datashite 1; Datashite 2)
I need to select the sheet through cell j1, before display data
i attach example

thank you

[aabonargis]

for UP for UP

[aabonargis]

for up for up

[JeteMc]

Try pasting the following into cell E2 and dragging down:

Please Login or Register  to view this content.

Note that it will probably end up being easier to combine the data from DataSheet1 and DataSheet2.
Let us know if you have any questions.

[aabonargis]

thank you for all

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.