Search results

Hello hea_ven, Thank you for your question. I have seen the file you attached and used two formulas to calculate the Amount Covered and the Amount not Covered. You can write the following formula in Cell C2 to calculate the Amount Covered and then drag the Fill Handle down to copy the formula...

Hello mfaisal.ce, Thank you for your feedback. Showing a progress bar while refreshing/updating the records is possible. Firstly, open the Visual Basic Editor >> select Insert tab >> select UserForm. Then, change the Caption, Height, and Width of the UserForm according to your preference...

Hey mfaisal.ce, Thank you for your question. You can use the following code instead of the code you used. Here, I have made some small changes to your code. Sub Update_Record() 'Procedure to Consolidate all sheets in a workbook On Error GoTo IfError '1. Variables declaration Dim Sht As...

Hello BigMe, Thank you for your question. You are getting the “invalid qualifier” error because you have used the closing parenthesis of the Sum function after the worksheet name as a result it is taking the worksheet as the argument. But the arguments of the Sum function can be a range of...

Hello bigme, Thank you for your query. I have created the following Macro for your example data. Sub add_data() Set my_rng = Selection Set rem_qty_cell = Sheet2.Range("I4").Offset(0, -1) If Sheet2.Range("I4").Value = "" Then Set act_cell = Sheet2.Range("I4") ElseIf Sheet2.Range("I4").Offset(0...

Hey jeannieg80, Thank you for your query. First, open a module in the workbook from where you want to copy the data. Then write the following code in that module. Sub Copy_and_Save_as_CSV() Dim my_Filename As String Dim my_WB As Workbook Application.DisplayAlerts = False On Error GoTo err...