dmt32

https://www.mrexcel.com/board/threads/vba-to-filter-multiple-sheets-based-on-a-cell-on-another-sheet.1095044/ I am trying to use this to solve my problem but keep getting error - vba subscript out of range error 9 Please help Private Sub Worksheet_Change(ByVal Target As Range) Dim ws As...

Hi, I am trying to change the color of a cell where variance is zero through conditional formatting. But since there are decimal values after zero, the system is not letting me apply conditional formatting. What formula should I put in so that conditional formatting ignores decimals after...

Hello Guys , i have this VBA code that generates auto invoice number , i could not change the code so that it increment the left 3 numbers by 1 , and check if month and year are correct my invoice number is : 001/mm/yyyy , 001 is the reference of the invoice Sub NextInvoice()...

here is code but i don't want to open it in current workbook ............ Sub GetDataFromClosedBook() Dim mydata As String 'data location & range to copy mydata = "='C:\[Newbook.xls]Sheet1'!$A$1:$C$12" '<< change as required 'link to worksheet With ThisWorkbook.Worksheets(1).Range("A1:C12") '<<...

Hi All, I have a database in which there are 3 columns named as Name , Category & New category. Name Category New Category George 5 1 Michel 4 1 Robert 4 7 Hunk 8 8 In the new category column, if any cell's value is <>1, then the same value require to be pasted in category column...