Search results

Hi, Slimline! 1) yes, it's optional, just make sure you replace it by the exact definition 2) to free resources (memory) used at allocation time 3) if you remove all the notes/indications (I only moved them) it works for any number of columns... check the defined named ranges in Formula tab...

Hi, emmatm! Emm... atm... what? workbooks... o_O... Oh!... those workbooks...:oops: Do you believe me if I tell you that I have absolutely forgotten about them? I'll take a bit more time to get back to you with something about them. What a pity! How much I like to be chased... well, another...

Hi, Eloise T! As stated at Chihiro's link they either are running automated tasks (scripts) over the Internet... or trying to become awesome in Excel. Regards!

Hi, Slimline! Give a look at the uploaded files. I defined 3 dynamic named ranges in Data workbook and 1 in Monitor workbook for easy referencing. I moved comments and explanations off table headers & columns. This is the code: Option Explicit Sub WithTheButtonItHasOtherCost() ' '...

Hi, Miranda868! Have you manually tested which cells of column J should fit into this CF? If not, please do it. Could you post the list, here or at a new worksheet, row numbers only? Thanks. Regards!

Hi, PaulF! If I were you and I had Excel 2010 in advance, I'd go for Chihiro approach. Nice one, I didn't think on it. Regards!

Hi, jb! We were just talking about it with p45cal. A doubt, line 13 is necessary, can we add a 14th line and hide it? Regards!

Hi, p45cal! I don't actually remember why I did it in such way, I can only thing that the middle line was part of an incomplete design. Let the OP clarify this. However, a little tricky adjustment maybe adding a new line after actual 13th and make it hidden. Or modify the code correctly. Regards!

Hi, Shawn Miller! Glad you solved it. I neither like nor knew if it was just a model or the actual file, but as I said, it was a Q&D approach. If upgrading to newer versions remember to switch to TEXTJOIN. Thanks for your feedback and welcome back whenever needed or wanted. Regards!

Hi, Miranda868! Welcome to Chandoo forums! Checked this yet? http://chandoo.org/forum/forums/new-users-please-start-here.14/ About your question, give a look at the uploaded file. I found that you haven't set rules for the 3 conditions described above, and that there were a lot of fractionated...

Hi, jb! Check the uploaded file at worksheet "table". Remember moving the code to the worksheet that you'll finally use. I removed the debug lines from the code: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) ' constants Const ki1stRow = 1 '0=even, 1=odd '...

Hi, sms2luv! If you have the password and write access to the network path were the original file is stored, then yes. Regards!

Hi, Shawn Miller! Quick & dirty: =SI(C5="X";C$4&", ";"")&SI(D5="X";D$4&", ";"")&SI(E5="X";E$4&", ";"")&SI(F5="X";F$4&", ";"")&SI(G5="X";G$4&", ";"")&SI(H5="X";H$4&", ";"")&SI(I5="X";I$4&", ";"")&SI(J5="X";J$4&", ";"")&SI(K5="X";K$4&", ";"")&SI(L5="X";L$4&", ";"") -----> in English...

http://bfy.tw/D89e

Hi, emmatm! I haven't learnt to think... in Spanish, so imagine about English. Regards!

Hi, Eloise T! ' start Let us go by parts, as Jack said in the London of the endings of XIX century... About what? About this: ' process We, @Marc L and me, have been knocking at your front door for half and our and nobody answered... and when a guy nicely uniformed (or it was disguised?)...

Hi, PaulF! Thanks for your kind words, hope the new times would be fine for your boss, otherwise tell him to give me a call. :DD The notation stuff. Once upon a time... All this began when in the early 80's the personal computer come to this world and users wanted to spreadsheet, even if they...

Hi, PaulF! Give a look at the uploaded file. I've added a few dynamic named ranges for easily referencing, a 3rd worksheet for copying/filtering/copying, a column with the no. of dates with qty in 1s sheet, and the number of days of the year to handle leap years. The main change is that I...

Hi, PaulF! Thanks for the clarification, don't need to worry about that. If I don't come back to you in a couple of hours I'll do on Monday. Regards!

Hi, Eloise T! Yes, you're right. What a wise person! How did you manage to figure it out? That's the last version of the code? I don't recognize it at of mine edition. Regards! <Edited> I've just uploaded my posted code into a blank module, compiled and didn't get any error. Verify the changes...

Hi, madcom! Welcome to Chandoo forums! Checked this yet? http://chandoo.org/forum/forums/new-users-please-start-here.14/ About your question, go thru this link and give it a try by yourself. If you face any issue, just come back...

Hi, jb! You can work on my uploaded file, then clear yellow backgrounds, check again all borders, then remove inter row/col blanks. Regards!

Hi, PaulF! Continuing with row 6, columns H:I, Start Date End Date 20/02/2017 11/03/2017 but there's only data from dates 20/02/2017 to 09/03/2017, not 11th, besides a few inner blanks. Is that correct or I should not even look at it? Regards!

Hi, gregorii77! Check your uploaded workbook, in worksheet Sheet 1 there's almost no data, cols A:B thru row 6, col C only row 2, and other columns empty. Regards!

Hi, PaulF! A couple of doubts. Let us take row 6 as example: a) Columns D:L of 1st sheet are the same as A:I of 2nd sheet. J column of 2nd is contains a row entry for: - each column in 1st worksheet from cols M:MN? - each column in 1st worksheet from cols M:MN for non-blank cells in row? (6 in...