MS Query - Parameter Question

[MarkAndrews]

When using MS Query, can you use a sheet tab (Jan, Feb, Mar etc) as the parameter, so the query will return the data held on that sheet?

TIA

 

[MarkAndrews]

Or what is the best way to achieve this?

 

[MarkAndrews]

Can anyone help with this please

 

[stuartford]

Bear with me here cause this isnt exactly what your looking for but it might be of help

there is a formula that you can type into excel that returns the Active Sheet Name you could use that as your look up criteria in the MSQ. now unfortunatly i cant remember how this formula is written and im struggling to get the search to work but im sure someone on here knows.

so not the greatest response but i hope its of some help

Stu

 

[stuartford]

Found the Formula

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

its from this post
http://www.mrexcel.com/archive2/66000/76529.htm

from many moons ago

Stu

 

[MarkAndrews]

Thankyou, I'll give it a shot