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: ua-cam.com/video/jyZHOIbHtv8/v-deo.html ua-cam.com/video/T4QMCoFlVdc/v-deo.html Also, I have some older videos to compare two worksheets (this is probably what you are looking): ua-cam.com/video/hZIFnKetyI0/v-deo.html And to compare 2 workbooks: ua-cam.com/video/4lLlX_pXoA0/v-deo.html And to compare 2 columns: ua-cam.com/video/UvnefIMtNnM/v-deo.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:
ua-cam.com/video/jyZHOIbHtv8/v-deo.html
ua-cam.com/video/T4QMCoFlVdc/v-deo.html
Also, I have some older videos to compare two worksheets (this is probably what you are looking): ua-cam.com/video/hZIFnKetyI0/v-deo.html
And to compare 2 workbooks: ua-cam.com/video/4lLlX_pXoA0/v-deo.html
And to compare 2 columns: ua-cam.com/video/UvnefIMtNnM/v-deo.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....