**Microsoft Excel cannot access the file** *Summary*: Microsoft Excel cannot access the file With reference to the post https://bit.ly/2DkM0f7 After all the above, 1- During the work, Suddenly, I face th...

**[Solved] Automatically move rows into a table on another sheet** *Summary*: I am using the macro code displayed below to automatically move rows of information from one sheet to another. Sheet 1 is named Current and Sheet 2 is...

**[Solved] Adding/Removing Rows in Source Sheets Auto Changes Master** *Summary*: I'm in need of a bit of coding help with our inventory document. I'm sure my question would be easily solved with a dedicated inventory program, but m...

**[Solved] How can I use a drop down list to populate other fields?** *Summary*: On one spreadsheet I have a list of food with the calorie, carb, and protein beside it like this:
A B ...

**[Solved] Can you search multiple cells for multiple values?** *Summary*: DerbyDad said I'd be back so here we go! This is part of a large report and goes along with the last two questions I asked. This item I am looking at...

**[Solved] Move a blue cell from one cell to another** *Summary*: How can I move the first blue cell from one ws to another? I used conditional formatting to select certain codes that came in from a string so there ...

**[Solved] How can I extract a word from a sentence in Excel?** *Summary*: I have information that comes back from an outside query like this: TE207: A change in the Customer's Country field (Out of Country).TE207: A change ...

**[Solved] Excel to Access-disappearing numbers saved as text** *Summary*: To clarify, we have account numbers of 15 characters and when they come to us from other reports in Excel, they're sometimes saved as text. When we'v...

**excel 2016 sheet 2 super slow& crashes often** *Summary*: a college of mine got an excel workbook with 2 sheets sheet one responds really fast, but when i switch to sheet to i get 30% cpu usage (so 1 core...

**[Solved] Does anyone know where All Experts went?** *Summary*: All Experts was a great site and one of their Excel experts, Thomas Ogilvey, was incredible at vba and macros. I asked him so many questions and he w...

**[Solved] Macro to insert a formula in a column** *Summary*: Hello, Me again. I've been struggling today trying to make a macro to insert an INDEX-MATCH formula in a column (since I can't seem to make it work ot...

**[Solved] Macro to remove some text with condition and add color shade** *Summary*: Hello, So I made a macro to format a table. I will post the macro below and there are comments that explain things. Here's how my table looks like: ht...

**[Solved] How to edit an excel email macro to send only 1 email?** *Summary*: Hello, I got a macro online for sending emails given a condition. It works great if you have 1-2 entries that require email sending based on the cond...

**[Solved] Queries in Excel for MAX Date?** *Summary*: I have an excel workbook with several sheets. One sheet (ClientTbl) is set up as the parent table and all other sheets (each on separate tab) are set ...

**[Solved] Excel formula to return number of days in a month?** *Summary*: I'd like to return the number of days in a month in column B, based on the date in column A. The problem is, column A does not have a specific date (0...

**[Solved] Can we do IF (And) with cell ranges?** *Summary*: This is my statement: = IF(or(G2='[Base.xlsx]Additional Customers Log'!$G$2:$G$500;K2='[Base.xlsx]Additional Customers Log'!$K2:$K500);"Duplicate";"Pe...

**[Solved] Automating date and time in excel help** *Summary*: I have a call tracker that I am trying to automate the input of the date and time. My time is not working correctly and my dates are changed for all e...

**[Solved] How to copy cell value from one workbook to another** *Summary*: Hello All! I'd really appreciate some help for a fellow Excel newbie! (pleeeeeease) I have Workbook1 with file names "SenFile" and durations "Slength"...

**[Solved] Microsoft Excel error: InvalidArgumentValue** *Summary*: Hello, InvalidArgument=Value The above message is coming when i am opening XLSX format file in Microsoft Excel. Can anyone out there help me? Is ther...

**[Solved] How to do an IF statement with multiple dates and criteria** *Summary*: So I am trying to create and IF statement that takes into account the submit date and the requested date for PTO wherein if the Requested Date is less...

**[Solved] Excel help - changing cell fill based on another cells fill?** *Summary*: Hi, Really stuck here and looking for some help. I have an excel sheet that I want to use to record the times people work a shift at work. The sheet...

**[Solved] Why is Excel 365 so slow?** *Summary*: I have Microsoft Office 365 ProPlus and I've been having issues using Excel recently. I'm not trying to do anything fancy, literally just colour text,...

**[Solved] Auto-insert new row on different worksheet on condition** *Summary*: Hi, I have a question very similar to another question that was answered in a thread on this site around a year ago. I found that thread very helpful...

**[Solved] How to add/remove specific rows based on input options.** *Summary*: I am really desperately hoping someone can help me with this. Sheet 1 Cell C3: Name Cell D3: User-Input Cell C4: Children Cell D4: Option of either "...

**[Solved] Is there a way to simplify this excel formula?** *Summary*: I'm trying to process a couple of values in Excel, and came up with this formula, which works: =$A3*B3+$A4*B4+$A5*B5+$A6*B6+$A7*B7+$A8*B8+$A9*B9+$A10*...

**Excel Formula to return cell value with matching text string** *Summary*: I am working on an excel formula that will return the value of the cell if the text string matches. the problem I am having is the blank cells where ...

**[Solved] Formula to check entry for duplicates in same column** *Summary*: I have this Excel sheet with just one column (A) in which I input just numbers in each row. I would like to create a formula so that each number, befo...

**[Solved] Excel formula parse error** *Summary*: Hello, Can someone please tell me why this is giving me a 'formula parse error'? =IF(ISBLANK(I6),ʺblankʺ,((((I6-I5)*2.3))+(((J6-J5)*0.26)))) Thanks....

**[Solved] Check & set the start date after another task end in excel** *Summary*: I have a schedule control Excel sheet, such as below Item Task Start End "predecessor task" 1 Gather requirement 2016/5/3 ...

**[Solved] Mid formula help on excel looking for 2 different symbols** *Summary*: If In say cell A1 has this text in it J DKNX CVIX K101 - M DKNX CVIC P191 How could I get cell C1 to show only M DKNX CVIC P191 If they are separat...