Converting PDF to Excel 2024 on Mac (Not O365)
Hello Guys, Looking for advice on converting a PDF to Excel on my Mac. I'm using Excel 2024 and not Office 365. Most of the solutions I've come across online seem to cater to Office 365 users. I need to convert PDF content into Excel format so that I can work with the content. Does anyone have suggestions with a step by step approach how to do so. If there is any macro available or any step which doesn't involve the use of third party tool I'm fine. Appreciate your help!
How to compare 2 excel sheets with an Unique identifier?
Hi! How do I compare values in sheet 1 and sheet 2, and display it on sheet3? Example: Sheet 1 has the following columns: ID Age Address Sheet 2 has the following columns: Age of bith Street Global ID How do I, on sheet 3, make the Excel able to compare for example, ID on the sheet 1 , it searches for a match in the sheet 2, and if it finds a match it says "match or no match" on sheet 3?WinFix Toolkit (All Windows 10 & 11 Repair Tools in One Excel)
After I published this small information tool (Excel (365 & 2016) with network information), several people contacted me and asked if I had a tool with Excel for general service tasks that, while available in Windows, are a bit scattered and confusing. So, I've prepared this small tool for Service Level 1, with most of the service options included. Hardware Repair Tools Repair Action Label Description Reset Windows Update Components UpdateReset Stops related services, renames cache folders, restarts services. Check System File Integrity (sfc /scannow) SFC Scans and repairs corrupted system files. Check Disk for Errors (chkdsk /f /r) CHKDSK Scans hard drive sectors and attempts repair. DISM Health Restore (dism /online /cleanup-image /restorehealth) DISM Repairs Windows image and component store. Network Reset (netsh int ip reset, netsh winsock reset) NetReset Resets TCP/IP and Winsock catalog. Flush DNS Cache (ipconfig /flushdns) DNSFlush Clears DNS resolver cache. Device Manager (open) DevMgr Opens Device Manager for hardware inspection. Software Repair Tools (examples) Repair Action Label Description Microsoft Office Quick Repair OfficeRepair Launches Office repair tool (Quick or Online). Reset Microsoft Store StoreReset Runs wsreset.exe to reset Store cache. Repair OneDrive OneDriveReset Resets OneDrive client (onedrive.exe /reset). Windows Defender Full Scan DefenderScan Triggers Windows Defender antivirus scan. Reset Windows Firewall FirewallReset Restores default firewall rules. Reset Windows Search Index SearchReset Rebuilds Windows search index. Clear Temp Files TempClean Deletes temporary files and folders. Reinstall UWP Apps (if broken) AppsReinstall Re-registers all built-in Store apps. I hope it might be helpful to some people. The tool has been tested, but it could still use some improvements, so I'd like to ask everyone who has looked at or used this tool for feedback. I would appreciate any constructive feedback or additional suggestions. Happy Excel-ing! *My tool are voluntary and without guarantee! NikolinoDE I know I don't know anything (Socrates)Macro to filter table to a searched result, then hide columns that contain a blank or a set value.
Hi All, I'm trying to figure out how to do the above. Essentially I have a list of assemblies and along the same row is a list of each part within that assembly. Not every sub-part is used in each assembly so there are blank spaces. I currently have a Search cell in B2 with a macro button next to it to Autofilter the table in B5 to the assembly I want to see. I'm struggling to get a reliable way to select the line that is visible after filtering so I can hide columns containing no information. Also if there are any better ways to hide the columns then seen below as I just recorded a macro of hiding them. The table I have spans from B5 to W808 currently. Range("C7:W7").Select works but the result will not always be in that row as only hiding cells above it. Sub Search() Application.ScreenUpdating = False If Range("B2") <> "" Then ActiveSheet.Range("B5").AutoFilter Field:=1, Criteria1:=Cells(2, 2).Value Rows(Cells("A2").Value).Select 'Doesn't Work Selection.SpecialCells(xlCellTypeBlanks).Select Selection.EntireColumn.Hidden = True End If Application.ScreenUpdating = TrueClash analysis for manufacturing hall
Hi all, I'm trying to build an excel sheet that has 3 "manufacturing bays" and when I list a move date & location against a piece of plate, that it moves a cell and recreates that live picture in that build hall. Initially I was trying to use some of the functionality in the (board game) Battleship excel templates to see if writing a VBA would allow for this/ linking it to a button. Something like the below: I then want it to highlight if two plates are likely to be moved into the same space at the same time as part of the clash analysis. Does anyone know if it's possible to build this level of functionality into excel through VBA etc
Error VBE6EXT.OLB
HolaWindows 10 home compilación 19045.5854, excel hoy presentó el error que no podía cargar "VBE6EXT.OLB" y si pincho en aceptar indica memoria insuficiente, también con un botón de aceptar. Intenté reparar la instalación (fuera de línea como a través de internet). Desinstalé y volví a instalar Microsoft 365. El problema persiste. Mi sistema tiene 32 GB, y funciona bien bajo carga, por lo que no es problema de memoria. Otras soluciones de internet que intenté fue limpiar la caché de excel y volver a registrar el archivo VBE6EXT.OLB, pero el problema persiste. ¿hay alguna otra forma de resolver la situación? Gracias. Daniel Castañeda AbarcaExcel (365 & 2016) with network information...and much more Information to Filter.
With Excel (365 & 2016) Network information, information about Local Network Connectivity, Test Connection to a Specific Web URL, WiFi SSID information ...and much more information to filter with a button. I was trying to create a tool that would allow me to filter the necessary information from all the PCs I need to work on using a USB stick. I came across an old file that I edited and added additional information to the code. I'd like to share this file (Help for self-help). If anyone finds it useful, or would like additional tips or information, please feel free to send me feedback. If it doesn't help you...just ignore it. I welcome any constructive comments. * After loading the file, be sure to activate all macros. Happy Excel-ing! 🙂
