it's been solved.....
the solution from easiest to hardest are:
www.asap-utilities.com/download-asap-utilities-free.php?file=1 (doesn't work for excel 2013 64 bit though :/
sorry i could not explain it better.... thank you..
*** OP ***
hey im trying to do hobby project and i have this really big problem: im trying to merge two spreadsheets with one sheet each into a new one. they should be merged based on matching ids in column A1:A1000, so the outcome would not have duplicated ids.
im assuming this is a common need but i couldn't find anything for excel 2013
please advise. link to a good video guide would be helpful and good.
Edited by office13broken, 03 September 2013 - 06:23 PM.