I am making an excel file wherein a macro is needed which will show only one sheet based on the data of the serial number and pick the data corresponding to that serial number.
A sample file is attached which will clarify more.
I am making an excel file wherein a macro is needed which will show only one sheet based on the data of the serial number and pick the data corresponding to that serial number.
A sample file is attached which will clarify more.
No VBA!
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thanks xld, one question Can I use VLOOKUP formula to get the result? If yes which one will be better - VLLOKUP or INDEX formula?
Yes, it will work just as well. As to which is better, the INDEX will be faster, but so negligible as to be irrelevant), but if you prefer VLOOUP, switch to that.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thanks I asked it for my knowledge only.