Forum Discussion
Merging Sheets
Is there a way to merge and sort similarities from 5 sheets to one sheet? For example, i have 5 sheets with all the same column headings "part number" "description" "Machine" and "Drawing number" bu...
copy all the data to one sheet in a new workbook, with one set of column headers at the top. Select the entire range of copied data and choose Remove Duplicates from the Data menu. This will scan through all rows and eliminate the duplicates. Please note that 2 or more rows are duplicates ONLY if all data elements match EXACTLY. You will still have to eyeball the remaining data to find rows missing data or rows that look like duplicates but have slightly different data - even something as minor as an extra space.