Importrange equals sheetname

[sirdon]

Hi all, I have a formula

Please Login or Register  to view this content.

Is it possible to have the where Col6 = "name of the sheet/tab" that the formula is currently sitting in?

I currently have the name of the sheet/tab in cell A2 using a code and formula =SheetName(), but was wondering if it could grab it directly from the name of the sheet.

Hope this makes sense. If you need an example please let me know.

Thanks,

[sirdon]

Here is an example

[Haluk]

Please Login or Register  to view this content.

[sirdon]

Thanks Haluk. That works just fine. Appreciate your help