Hi,
I have a question please help me out...
I have 3 excel spreedsheets, say ABC DEF GHI
now in three excel sheets there are 5 colomns with same header name however they are not well placed means their places/positions are different in each sheet
For example in ABC sheet the colomns are Name age dob doj qual,. But in DEF the colomns are Name doj dob age qual and in GHI it is doj Name qual dob age...
Now I want my excel mastersheet(a forth sheet) where all the datas will automatically gets copied according to it's colomn name, i.e. the names from all three sheets will be copied under name colomn automatically in the mastersheet & so on...
Thanks in advance
Bookmarks