bloubul
Member
Compare Two Sheets and Report.
Hi All.
I’m looking for a macro / formula to do 3 things.
1. It must be able to compare 3, 5, and 6 numbers. (Up to 75 numbers)
2. Sheet_M is the master sheet.
3. Sheet_T is the target sheet.
4. Than create a report on the Report sheet.
5. Create headers on the Report sheet.
The working of the macro / formula.
1. Take the 1st draw on Sheet_M and then run through all the draws on Sheet_T and put it on the Report sheet as indicated. It must be able to allocate the numbers of Sheet_T in the exact position as it is on Sheet_M. (See example of “Report”).
2. Once finish with the 1st draw of Sheet_M and all the draws of Sheet_T, than it goes to the 2nd draw on Sheet_M, and repeat all till the last draw on Sheet_T.
3. The number of draws on both sheets will not exceed 3000 draws.
4. In the reporting part of the macro it must give me the option to select = 2 numbers, or = 3 numbers or > 3 numbers etc,etc.
Here is a copy of the sheet.
http://www.mediafire.com/file/5e4kccgbg0lbyz2/Compair_Sheets.xlsx
I thank you all.
BlouBul
Hi All.
I’m looking for a macro / formula to do 3 things.
1. It must be able to compare 3, 5, and 6 numbers. (Up to 75 numbers)
2. Sheet_M is the master sheet.
3. Sheet_T is the target sheet.
4. Than create a report on the Report sheet.
5. Create headers on the Report sheet.
The working of the macro / formula.
1. Take the 1st draw on Sheet_M and then run through all the draws on Sheet_T and put it on the Report sheet as indicated. It must be able to allocate the numbers of Sheet_T in the exact position as it is on Sheet_M. (See example of “Report”).
2. Once finish with the 1st draw of Sheet_M and all the draws of Sheet_T, than it goes to the 2nd draw on Sheet_M, and repeat all till the last draw on Sheet_T.
3. The number of draws on both sheets will not exceed 3000 draws.
4. In the reporting part of the macro it must give me the option to select = 2 numbers, or = 3 numbers or > 3 numbers etc,etc.
Here is a copy of the sheet.
http://www.mediafire.com/file/5e4kccgbg0lbyz2/Compair_Sheets.xlsx
I thank you all.
BlouBul