Search results

Hi, Eloise T! This is the 3rd post, July 24th... had tried that and could have solved the issue 18 days ago. Regards!

Hi, Tom90! A way to do it with formulas is this: At any cell: =SI.ERROR(DESREF(Hoja1!A1;;-8+CONTARA(Hoja1!1:1));"") -----> in English: =IFERROR(OFFSET(Hoja1!A1,,-8+COUNTA(Hoja1!1:1)),"") Then copy across and down as required. Regards!

Hi, Izhar! Check the updated file, code added for worksheet change event: Private Sub Worksheet_Change(ByVal Target As Range) ' constants Const ksOp = " < = >" Const ksRng = "FilterList" ' declarations Dim sOp() As String Dim rng As Range Dim I As Long, J As Long, K...

Hi, Tom90! Consider uploading a sample file. It'd be easier to understand for people who might be able to help you. Include indication of the input data, the attempted solution (formulas, code) and the manually written expected output data as example. Thanks. Regards!

Hi, Izhar! Give a look at the uploaded file. It uses cells instead of text boxes, filter expressions should be put in full condition format (carlsberg for carlsberg, *carlsberg for ending in carlsberg, carlsberg* for starting with carlsberg, *carlsberg* for containing carlsberg... <1000 for less...

Hi, Eloise T! Beware if it's the roadrunner disguised as train driver and you're still playing the coyote role. Regards!

Hi, azumi! In your uploaded workbook data range at column A goes from A1:A7 and formulas use A2:A8. Output formulas at D4:D5 are array formulas, when both of them could be normal ones. Besides, you're using "<" and ">" which may be a request interpretation. westend9876 should go for "<=" and...

Hi, mithil1! Just missing worksheet qualification (in bold red): =INDICE(Hoja1!$A:$A;(FILA()-1)*5+RESIDUO(COLUMNA();5);1) -----> in English: =INDEX(Hoja1!$A:$A,(ROW()-1)*5+MOD(COLUMN(),5),1) Proceed as described above. Regards!

Hi, Kellis! Check if this is suitable for you, the first part (JLL file) does something very similar to your requirements. http://chandoo.org/forum/threads/copy-data-from-various-sheets-onto-a-master.35180 Regards!

Hi, VincentF! Check this threads, maybe you find something that fits your requirments: http://chandoo.org/forum/threads/copy-data-from-various-sheets-onto-a-master.35180 http://chandoo.org/forum/threads/matrix-to-list-database.35258 Regards!

Hi, Eloise T! Where shrivallabha wrote one, please read two or three. I.e., read more & write less. :p Regards!

Hi, Nandakumar! Here you have an example of how to convert declarations from 32 to 64 bits Excel versions or how to use them both. As I don't have any machine at a hand that runs Excel x64 I'm afraid that I won't be of further help. Option Explicit #If VBA7 Then Private Declare PtrSafe...

Hi, Frank Bacchus! Give a look at the uploaded file. This is the VBA code for worksheet Issues object: Option Explicit ' global constants Const gkiFilter = 4 Const gksFilter = "Completed" Private Sub Worksheet_Change(ByVal Target As Range) ' constants ' declarations ' start...

Hi, sms2luv! The trick of the 1-byte change with an hex editor works only for .xls files if I far as I remember. Later with .xlsx file structure it doesn't work anymore. These new files have first structure level of .zip/.rar files, just rename any *.xls? file to those extensions and you're...

Hi, emmatm! Give a look at the uploaded files, they're not fully tested but that's your homework. Just advise if any issue. Regards!

Hi, mithil1! In a new worksheet, in A1: =INDICE($A:$A;(FILA()-1)*5+RESIDUO(COLUMNA();5);1) -----> in English: =INDEX($A:$A,(ROW()-1)*5+MOD(COLUMN(),5),1) Copy across to D1 and down as required. Regards!

Hi, dankos233! For the letters sample, shouldn't these be the pairs? a,d a,c b,d e,d And these for the numbers? 10,80 42,45 10,26 10,45 Regards!

Hi, dankos333! Welcome to Chandoo forums! Checked this yet? http://chandoo.org/forum/forums/new-users-please-start-here.14/ About your question, you've posted it the wrong forum, as this is just a place to introduce yourself to the community. Would you mind introducing yourself here below and...

Hi, shrivallabha! Never say never again... Eloise T has a lot of creativity... Regards!

Hi, Ufoo! Maybe I misunderstood your question but... Excel store dates as integer numbers starting for 01/01/1900 as 1. That's about storage. Excel show stored dates according to the cell format, i.e., it maybe dd/mm/yyyy, mm/dd/yyyy, dd-mmm, including dd, mmmm... Taking the above date as...

Hi, MonioDee! As Hui asked you, do you have backups of the original .xlsm file? Regards!

@shrivallabha Hi! Don't tell me that I didn't tell you... :rolleyes: Regards!

Hi, Slimline! Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted. And a general advice any time you have issues with code (even more if you modify a provided code that was working), debug it line by line with F8 from the first to the last line, checking the...

Hi, Derek B! From Excel menu, File, Help, and you get a bunch of things including version. If those folders are empty and the problem persists after uninstalling and reinstalling the add-in, I'd go for Office uninstallation and reinstallation. Regards!

Hi, Eloise T! At the edition or input bar, either if you press the "f(x) " at the left or if you input "=<function>(" (unquoted) you're led to the function built-in help, which is classified by function type. There you can read the related help, and as you type the formula, you're prompted for...