Merge Excel data in one sheet.?

Question

I've two worksheet in an excel workbook. One sheet containing some data & another sheet containing same data with extra data. I want to merge both data in one worksheet & extra data want to show in last rows.

Answer 1

first make a copy of both the excels because if didn't work you won't lost your data.



1) What is the point in merging these two excels when you have one excel with all the data plus extra data.

By copying the extra data to the previous excel you'll get the new excel with data in 2nd excel. Its pointless.



2) Copy & paste either of the excel in another excel sheet (under the current data) and and click on the options "remove duplicates".



3) You can use filters to filter new extra data and then copy paste it in earlier excel.



Hope this will help..

Answer 2

You are able to do it robotically utilising macro. If which you could specify the region of those records, create a FOR each file loop and skim the content material of each file, then write it on a new worksheet. The code itself won't take greater than 100 strains. Be conscious also of row hindrance of excel documents, on version 2003 and beneath that you would be able to best have approx. 65k of rows.

Answer 3

Maintain duplicate data in one sheet and give hyperlinks for extra data. It will be looking good.

Answer 4

Yes^^^