新聞財經娛樂♬資訊 News Economy

Imagine you want to compare the visible columns on the sheet for the last month to the other sheets.
So here is a function to do that.

You will be asked "Select a cell on the sheet to compare the other sheets to".
Now it is Jun14, but then it will also work next month.
Just select any cell on the sheet, and press Ok.
Only the columns that match the headers for the visible columns on the selected sheet will be copied. If the header is missing, you get a warning and the program stops.
The sheets will be named "Jan14 to Jun14" etc.

The sheets are not identical in structure.
Sheet Jun14 has 3 columns A:C more than the others.
For the sheets Jan14 to Apr14 the column headers A:DP match the headers D:DS on Jun14, but for May14 the column headers X:AH and AT:BD are different.
What exactly do you want to compare?

So what I want to do is compare Jun14 sheet with each of the other sheets (Jan14, Feb14, Mar14, Apr14, May14) individually and if there is a row on Jan14 etc. and it does not exist on Jun14 to copy that row from Jan14 to New Sheet1.

Hello,

Well what I am trying to accomplish here is to compare each sheet individually against the Jun14 sheet and take the rows that are not on the Jun14 but are on the other sheet example the Jan14 sheet and copy those rows from the Jan14 sheet that do not appear on the Jun14 sheet to a new sheet that I can use to see what merchants I have lost since Jan14 each month in comparison to what I have currently on Jun14.  Does that make sense?