Get instant live expert help with Excel or Google Sheets

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I share an excel online sheet with three other work colleagues, and the sheet keeps changing itself to English (US), rather than English (UK). All our computers are set to UK, as well as our profiles on our Microsoft Accounts. Please help us keep it in the UK settings!
Solved by V. U. in 14 mins
Need to improve existing code to accomodate multiple file extensions instead of just pdf xlsx etc... and to only run code once, instead of once per extension. My excel files are very large and I would like to set it to run and walk away so when i return it has finished searching for all extensions i specified and moved the lines to a new sheet. Here is the code and some snipits of code that may help. Keep in mind the following instructions: 1. "Source" sheet is the file that contains your database 2. You wil have to add a blank sheet to workbook and name it Destination 3. .pdf and .xlsx and more are the extensions extracted to Destination using this code. 4. Run the code once, all .pdf extension files will be xtracted to Destination, then run the same code again, all .xlsx will be extracted to Destination below the .pdf's Sub Extraction() Dim xRg As Range Dim xCell As Range Dim I As Long Dim J As Long I = Worksheets("Source").UsedRange.Rows.Count J = Worksheets("Destination").UsedRange.Rows.Count If J = 1 Then If Application.WorksheetFunction.CountA(Worksheets("Destination").UsedRange) = 0 Then J = 0 End If Set xRg = Worksheets("Source").Range("F2:F" & I) On Error Resume Next Application.ScreenUpdating = False For Each xCell In xRg If CStr(xCell.Value) = ".pdf" Or CStr(xCell.Value) = ".xlsx" Or CStr(xCell.Value) = ".xls" Or CStr(xCell.Value) = ".doc" Or CStr(xCell.Value) = ".docx" Then xCell.EntireRow.Copy Destination:=Worksheets("Destination").Range("A" & J + 1) xCell.EntireRow.Delete J = J + 1 End If Next Application.ScreenUpdating = True End Sub Code Snips for re-use To Search for Extensions in bulk Sub ConvertWordsToPdfs() Dim directory As String directory = "C:\Wordup" ' The starting directory Dim fso, newFile, folder, files Set fso = CreateObject("Scripting.FileSystemObject") Set folder = fso.GetFolder(directory) Set files = folder.files For Each file In files Dim newName As String newName = Replace(file.Path, ".doc", ".pdf") Documents.Open FileName:=file.Path, _ ConfirmConversions:=False, ReadOnly:=False, AddToRecentFiles:=False, _ PasswordDocument:="", PasswordTemplate:="", Revert:=False, _ WritePasswordDocument:="", WritePasswordTemplate:="", Format:= _ wdOpenFormatAuto, XMLTransform:="" ActiveDocument.ExportAsFixedFormat OutputFileName:=newName, _ ExportFormat:=wdExportFormatPDF, OpenAfterExport:=False, OptimizeFor:= _ wdExportOptimizeForPrint, Range:=wdExportAllDocument, From:=1, To:=1, _ Item:=wdExportDocumentContent, IncludeDocProps:=True, KeepIRM:=True, _ CreateBookmarks:=wdExportCreateNoBookmarks, DocStructureTags:=True, _ BitmapMissingFonts:=True, UseISO19005_1:=False ActiveDocument.Close Next End Sub OPENING MULTIPLE FILES Sub OpenMultipleFiles() Dim Filter As String, Title As String, msg As String Dim i As Integer, FilterIndex As Integer Dim Filename As Variant ' File filters Filter = "Excel Files (*.xls),*.xls," & _ "Text Files (*.txt),*.txt," & _ "All Files (*.*),*.*" ' Default filter to *.* FilterIndex = 3 ' Set Dialog Caption Title = "Select File(s) to Open" ' Select Start Drive & Path ChDrive ("E") ChDir ("E:\Chapters\chap14") With Application ' Set File Name Array to selected Files (allow multiple) Filename = .GetOpenFilename(Filter, FilterIndex, Title, , True) ' Reset Start Drive/Path ChDrive (Left(.DefaultFilePath, 1)) ChDir (.DefaultFilePath) End With ' Exit on Cancel If Not IsArray(Filename) Then MsgBox "No file was selected." Exit Sub End If ' Open Files For i = LBound(Filename) To UBound(Filename) msg = msg & Filename(i) & vbCrLf ' This can be removed Workbooks.Open Filename(i) Next i MsgBox msg, vbInformation, "Files Opened"' This can be removed End Sub
Solved by I. E. in 21 mins
I need help converting a portion of my excel sheet to a pdf on my MacBook pro
Solved by O. D. in 22 mins
I need help with a work schedule I have made in excel
Solved by Z. W. in 26 mins
I have a calendar in Excel and that I want converted to a Google sheet. I am unable to get the formula's to work in Google. Can you help with that?
Solved by I. B. in 23 mins
I am the bookkeeper for an attorney. We are mediating garnishment payments for a client. I have made an excel sheet but I think it could be a little easier and user friendly. As of right now, I'm the only one that can use it because I'm the only one who understands the formulas. Do you help make worksheets?
Solved by M. H. in 25 mins
Hi! I want to code my excel so that it will copy the data from multiple cells to another location using conditional formatting. For example, if the word in cell D4 is not equal to the word in cell E4, I want it to copy cells B4, C4, D4, and E4 to another location on the document. Furthermore, I would like to have this run through multiple rows without leaving spaces in the "copied" area. I could code it as an if statement (which would take forever because i have a lot of data) but I don't think it would allow me to have as many in-bedded if statements as I need. Thank you for your help!
Solved by K. L. in 20 mins
Need help creating an excel sheet that takes information from one column in another sheet to automatically update the corresponding row or information in the master sheet.
Solved by S. H. in 22 mins
Hi I got a problem about my excel file that i want to combine 2 conditions in the same file and i can't figure out it. please help :D
Solved by S. A. in 29 mins
Hi, i need some help with a spesific problem with excel. For example that collumn A1 to A20 wil go to collumn F1 to F20 in between , and / or that collumn A1 to A20 wil go to column F1 to F20 an wil pick a certain text from column which wil be replased wit text from folumn A ? More clearly i have 10 columns in excel and i need for example one column A 1 to A20 go to the othe column for example F1 to F20 but columns F1 to F20 contains URL adres and columns A1 to A20 hase to go in to the URl.... is it possible that excel can find specific text in url which wil be replased with other column?
Solved by M. B. in 26 mins