bit

Hello, I have the following question, how can I compare two files from an excel one is with 1000 rows and the other with 300 rows a bit how can i check which rows are missing In principle, both files must be the same. 10x

Hi I am a bit stuck with this and i need a bit of help I have a list of products that needs to be divided into equal groups by Weight and Order value. I cannot add the img tag so i just leave the link below: https://ibb.co/XLWk4Yb Thank you

I have an Excel application written in Excel 2010 64 Bit. Everything has run fine for months but I needed to add a Chdir command and ran into a problem. I added in a Private Declare PtrSafe Function SetCurrentDirectoryA Lib "kernel32" (ByVal lpPathName As String) As Long to my code and...

Hello, I'm looking for a VBA code that returns if there is an internet connections. There is a lots of code out there but the problom is that I didnt found a code that actualy works no matter what type of Excel version the user have (I mean 32 BIT or 64 BIT). I will be happy for help on this...

Hi I just watched a video and he said that to do =A1:A6-B1:B6 I need to press CTRL+Shift+Enter I selected cells C1:C6 then typed =A1:A6-B1:B6, in cells C1 and pressed Ctrl+Enter only and I got the right answers. So how come that works without using Array? I am a bit confused here. Thank you...

Sir I have created a vba macro in Windows 7 64 bit and that is working fine in my laptop . But when I opened the xlsm file in a 32 bit system the developer design mode is greyed out and all macros are disabled. There is no option to enable them. Kindly suggest how resolve it...

Hi there, I have a macro to auto zoom to a range when someone enters a sheet as this is where all the input fields are: sub enterSheet() ActiveSheet.Range("T1:CZ1").Select 'set range zoom ActiveWindow.Zoom = True end sub Is there an extra bit of code that I can slide in there to center this...

Hi i need to sort sheet2 rows by Id number in column D from Sheet1 order. So whatever order sheet1 is in by id number I need sheet2 to look the same. The reason why I cant sort sheet1 id numbers by numbers then sheet2 is because. The order that Sheet1 is in I need it in the same order on sheet2...

I have a very strange issue going on as follows: If I open a workbook, a "mystery" sheet opens up shortly after I open the workbook. If I close the mystery workbook, it closes the original file I opened up. There are no cells displayed and the ribbon is not displayed in the mystery workbook...

Hello all, I ave just completed converting decimal to binary without the use of DEC2BIN. However now I am moving onto converting this concatenated 8 bit binary number into Hex, without the use of BIN2HEX. What I have done so far is set up a vertical table with two columns, one with 16 values...

Good morning, I am building a tech tree/flow chart and I had an idea to make it a little more user friendly as it may become quite convoluted down the road. The idea would be to highlight/color change any connected lines/arrows when selecting a specific point(shape) in the chart. I tried a...

Hi guys, I'm trying to include the max statement in formula below, so the last bit is < max of column AC. Any ideas? COUNTIFS(n!AO:AO,1,n!D:D,"<"&W68, n!A:A,"<" max:(AC))

I have a record set with ~17K records, but I only need to see ~500 of them. I'm unable to alter the source of the data that I receive, so I'm trying to delete the rows I don't need, via VBA. I haven't tried using the Evaluate function before, and for some reason, I'm not able to get this to...

Hey Peeps, This one is a bit hard to explain for me and that's why the title is a bit weird. I hope someone can help me out on this as this will ease up things. I would like to have the following: If A1 = B2 and A2 = B42 So as you can see the pattern is of every 40 cells. Is there a formula...

If I have this to false and then use those workbooks in my script will excel error? currently I’m hiding/unhiding sepetate tabs which gets a bit messy if one is already hidden or unhidden.

Hi guys, I spent ages browsing the net to no avail. I'm trying to get this to work: =SUM('Permit 17-18'!C49:ADDRESS(39,COUNT(C49:N49),4)) but Excel doesn't like it. Address bit is basically E49. How on earth do I get Excel to accept E49 so it processes: =SUM('Permit 17-18'!C49:E49) Thanks!

=IF(AND(W6<>"",VALUE(W6)=VALUE(TODAY()+1)),"Due in 24 Hours",1) Hello, Why is the above formulas second part of the If statement volatile? This bit: VALUE(W6)=VALUE(TODAY()+1)) Many thanks.

What should I get paid for creating/solving Excel/VBA things in the UK? Wondering because my contract (for data processing) is coming up for review and I've been doing a wee bit more than data processing. Any input would be great. Norie

Hey guys, I'm not great at macros but I can imagine there is one that can help me, I'm just not sure how to make it. This will be a bit hard to explain because I'm not sure how to share a workbook on this forum so if someone can explain how to do that real quick it'll save a lot of trouble...

Hello, I recently changed from office 32bit to office 64bit as I had hoped that it would bring an increase in performance. I have one macro that I use regurlarly, it searches through lots of arrays generated from csv data imported to memory. This macro took two and a half minutes te execute on...