zot

Hi All I have created a COPY button and a CLEAR button on an Excel file. And I have been using it for 3 months without any problems. Suddenly the Error below came out when I click COPY button. CLEAR button no problem. I just want to know, is this error related to my VBA code? I have...

Hi All, I need help to edit below formula. I want to autofill the formulas starting with the IFERROR (G2) in the column G until the last row that contains the data in the cells next to it (Column C, D, E & I). Column C,D, E & I is the cells that the IFERROR refers to. Sub fill_all_column()...

Hi Everyone.. I have used the VBA code below to transfer data from another sheet to another sheet before. ___________________________________________________________ Sub RoundedRectangle6_Click() Dim wsIN As Worksheet Dim wsRegister_IN As Worksheet Dim CopyLastRow As Long Dim DestLastRow As...

Hi everyone! Actually I already use below formula to copies data from another sheet to another sheet. That is, by clicking one bevel button, then all the selected data will be pasted to another sheet. Sub Bevel2_Click() Dim wsRegister_IN As Worksheet Dim wsDatabase As Worksheet Dim...

Hi everyone! Actually I already use below formula to copies data from another sheet to another sheet. That is, by clicking one bevel button, then all the selected data will be pasted to another sheet. Sub Bevel2_Click() Dim wsRegister_IN As Worksheet Dim wsDatabase As Worksheet Dim...

Hi All, I would like to match the Data IN and Data OUT in my Database. I have used the formula below to match the data before. =IFERROR(INDEX('Register OUT'!$A$3:$K$2000,MATCH(1,(DataBase!$C$2='Register OUT'!$C$3:$C$2000)*(DataBase!$D$2='Register OUT'!$D$3:$D$2000)*(DataBase!$E$2='Register...

I need a formula to make the connection between the data from sheet A (before I transfer the data to sheet B) to another sheet C which is in the form automatically. The data in sheet A will always change as each incoming data will be transferred to sheet B and will delete all the original data...