Search results

Will do! Thanks for your help, it has been very useful and helped me a great deal! I will explore about this BYROW and LAMBDA :)

Hi @Monty, Thank you for your answer and I appreciate the effort, however the ranges don't match with the ranges in the original file. For example in column H there is not data in my file Maybe you moved columns on your side and it doesn't reflect the position on the original file.

Hi @p45cal, Works very well, thank you! I'm trying to understand exactly how it works, I'm struggling with the LAMBDA function. I've never seen it in a formula, could you explain what's its role? Thanks!

Hello all, This is a bit tricky topic on which I have been pulling my hair (or what's left of it) for the last 2 days. I have a big data base of stock movement with many information, the most important being the family, movement code and type. For each movement, I created a summary table with...

Hello all! @p45cal and @Peter Bartholomew , thank you very much for different solution, I definitely wasn't aware it was possible to solve this problem with a power query, or this kind of code in formula. This is some high end approach, from what I can see it works perfectly and I have to check...

Hi @John Jairo V Thanks a lot! Amazing formula! The formula seems to do the trick when there is only a single day in the data, but when I add several days, it will also give me a position of the last mission perfomed for D-1 for the first mission peformed on day D. For the first mission...

Hello, I work in warehouse where users move goods from one position to the other. I need to calculate the average position moved between the end of a mission and the start of the next one (=empty movement) for each user. In the data I can extract, I know the date-time of the end of the mission...

@vletm: I apologize for this, I'll make sure to be careful respecting the rules. Thanks to Logit's answer, I was able to modify his code and have a macro that works exactly as I needed.

Regarding the team, I have a list of worker (column A in tab Teams) and their respective team (CE1 or CE2) in column B About VBA, to be honest I'm not able to write anything "from the top of my head" but I'm usually able to pick some bits of code here and there and am able to understand them...

Hello @BobBridges, Thank you for your message, I appreciate your answer but as I'm not very good at VBA, this code is not really understandable for me... ?? How do you define the team? And the number of people in teams? If you can define a bit more, that would be great! Thanks!

Hello, I'm looking for a way to assign randomly workers to a workstation. Workers are divided in 2 teams, so if I have 18 workers in team 1, they should be assigned randomly to position 1 to 18, and if I have 19 workers in team 2, they should be assigned to position 19 to 37. I'd need a macro...

Hello, I'm working on a chart where I view performance between 2 dates that I enter. The only thing is when I have a weekend or dates with no data, I see it anyway in my chart. I tried to use the "text" formatting for my axis, but then I need my data array to be dynamic and as I use a FILTER...

Perfect, thanks Alan :)

Wow, thanks a lot for all these explanations. That's a lot of information to take in, I have to read and dive in it calmly and test these code lines. I will get back to you in maybe a few days but I'm really grateful for taking the time to explain it thoroughly, it helps me a lot to better...

Hello, I would like to extend down (until last filled cell) the formatting of range A2:C2. When I record macro I have the following: Range("A2:C2").Select Selection.Copy Range(Selection, Selection.End(xlDown)).Select Selection.PasteSpecial Paste:=xlPasteFormats...

Ok, thanks to your great help I was able to adapt and it runs well: now the macro is running is 15-16s instead of 30 to 40s! The code is indeed much cleaner and I start to understand why not to use activate and select (even if the set and with isn't totally crystal clear yet :p) I have a...

Hello Jolivanes, Thanks a lot for your help! :D Yes, as you probably guessed I'm not a vba expert and most of the time putting together pieces of code that I find and adapt to my needs, but probably not in the best way ;) I have a question regarding the val variables and what they are doing...

Hello, I managed (with some help from here ;)) to write a macro which automatize the copy/paste data from a closed workbook that I can select to another one. The final destination workbook is a bit heavy (ca 6 Mo), while the original workbook is quite light (50ko). I copy data from different...

Nice! Thank you :)

Hello, I have this piece of code which allows me to select an Excel file, copy a range of data and paste it from cell A10. I would like to modify it in order to paste data to last empty cell of column A Sub Get_Data_From_File() Dim FileToOpen As Variant Dim OpenBook As Workbook...

Hello, I have a list of people with delivery dates, customers and information if payment is confirmed. I am looking for a formula to extract from this list a list of deliveries which are late (meaning the delivery date was schedule before the date of the day) AND payment is confirmed. I put in...

Small precision, when I say top 3, it means from cheaper price to most expensive :)

Hello, I have a transport matrix with give me transport cost to deliver different number of pallets to different area codes for several transport company. In a separate sheet, I would like to have formulas which would give me the top 3 with company name and associated price, when the user enter...

Works nice, I'm going to save some time :) Thanks a lot Hui!

Hello, I would like to automatize the print of a document for drivers: on an excel file I have one sheet with the paper to give to driver with the route number and some different info, and another sheet, I have the list of all route numbers. I would like to automatize the printing of the sheet...