Hello!!
I am willing to copy a data from a column in each of different sheet (column ceredential is same) to one column is one additional "exclusive sheet".
The selection criteria is that i have made data validation in that exclusive sheet. Whenever I chose an option from that drop down, excel should go to that respective sheet and give me option to select a value from column which i want to add to a column in "exclusive sheet". All the column will have field title name same which will help in ease navigation and identification.
Can anyone suggest as to how will it be done, will a Macro be required or IF and VLOOKUP can help.
If so plase help me out with formula string for the same.