Love your videos and easy to learn...can you able to make a VBA for validating sheet1 and sheet 2 as compare with unique numbers from both the sheets and bring out the data only which are not matching with both the sheets and our criteria should be date or quarter
Glad you like it. What you are asking is more related to some other videos, please check those because it may have what you need. I have a mini-series to compare everything in Excel, these 2 are about comparing worksheets: ruclips.net/video/jyZHOIbHtv8/видео.html ruclips.net/video/T4QMCoFlVdc/видео.html Also, I have some older videos to compare two worksheets (this is probably what you are looking): ruclips.net/video/hZIFnKetyI0/видео.html And to compare 2 workbooks: ruclips.net/video/4lLlX_pXoA0/видео.html And to compare 2 columns: ruclips.net/video/UvnefIMtNnM/видео.html
@@ExcelMacroMania thanks for your response... comparison is ok after comparing I am looking for reconciliation it's more like comparison two accounting sets...and pull the data where only variences from both the sheets using multiple criteria I know it's too much to ask but am also looking at your videos and learning and taking points on how to ease my tasks....
Thank you so much
Is there any we can the suggestion of the custom function in other sheets also?
The custom function can be used in any sheet, and if it's public, even in any workbook if the workbook with the function procedure is open.
Love your videos and easy to learn...can you able to make a VBA for validating sheet1 and sheet 2 as compare with unique numbers from both the sheets and bring out the data only which are not matching with both the sheets and our criteria should be date or quarter
Glad you like it. What you are asking is more related to some other videos, please check those because it may have what you need. I have a mini-series to compare everything in Excel, these 2 are about comparing worksheets:
ruclips.net/video/jyZHOIbHtv8/видео.html
ruclips.net/video/T4QMCoFlVdc/видео.html
Also, I have some older videos to compare two worksheets (this is probably what you are looking): ruclips.net/video/hZIFnKetyI0/видео.html
And to compare 2 workbooks: ruclips.net/video/4lLlX_pXoA0/видео.html
And to compare 2 columns: ruclips.net/video/UvnefIMtNnM/видео.html
@@ExcelMacroMania thanks for your response... comparison is ok after comparing I am looking for reconciliation it's more like comparison two accounting sets...and pull the data where only variences from both the sheets using multiple criteria I know it's too much to ask but am also looking at your videos and learning and taking points on how to ease my tasks....