Oct 24, 2022 · The loading sheets have barcodes at the bottom which I scan into my table. They're in the format T<trip><date_as_yyyymmdd>V<van_number>, i.e. …

Mar 31, 2021 · I'm working on a formula for a golf social annd I've got all but one thing worked out. Below are the rules If you win you get cut 0.5 37 points and above you get cut 0.2 per point 33 …

Apr 26, 2012 · Finally, I am loading into Excel to QC my work because I am also new to PowerBI. But, I eventually want to get my finalized query into powerbi. Is there a way to copy a query …

May 7, 2020 · Hi, MickG wrote some code to load pictures from a spreadsheet into a userform. Worked well But I want to know how it can be adapted to load Shapes / msoPictures from a …

Jul 23, 2011 · I need to import a worksheet table into a VBA array. I found several solutions, but they all seemed unnecessarily complicated. One even involved about 20...

Aug 1, 2021 · Amigos, ya he publicado este tema en el foro en inglés pero como no tuve respuestas satisfactorias he creado este tema en español. Espero no haber roto ninguna regla …

Apr 11, 2013 · Excel has a 1 million row limit. Power Query can handle a lot more rows. My understanding is that to manipulate data, one can use Power Query, then close and load back …

Oct 26, 2021 · My pivot table name is correct, and it's on the worksheet called "Report", the filter is called "Short" and there is a value in B3. I've had the code in "This Workbook", in the "Report" …

Feb 17, 2023 · Hi all, I know there are solutions for this but I just need help incorporating them into my code. The code runs 1 time and does not loop because I have 2 directories open, so the …

Mar 31, 2022 · Wondering if there is a fix to get I+M working on tables in different sorting configurations, or if there is a similar formula/combination to get it working as intended. Sheet …