Excel Related Problems & Solutions

2,705 tags
Refine Tags
Search Tags:

Start a discussion

Results 1 - 30 of 2705
[Solved] Loop Sheet1 names and Find each on matrix in Sheet2 & then
Summary: I have an order fulfillment worksheet (Sheet1) with 700 names. In same workbook, there are 10 other worksheets that match orders from various custome...

Excel VBA Macro Convert Number to Percentages
Summary: Good afternoon, I am wondering if it is possible to make a vba macro where i have columns in random order from numbers 1 to 5. Each number should repr...

Issue when any 2+ worksheets are open
Summary: I am not sure if I will be able to explain this very well but here goes: So I have 2 excel files open, it doesn't matter if they have formulas or not,...

How to Combine Today() and If Statement in unique ID
Summary: In excel I am trying to combine the date today and my unique ID. on where: B2 = 0 B3 Fomula is =IF(ISBLANK(I3),"",B2+1) B3 = 1 but i need it to show l...

[Solved] I want to assign value for name
Summary: Hi All, I have team 3 members i want show their work status in graphical it will change dynamically Work Points Staff String 10 ABC Search 20...

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*...

123456789... ⇓»

Popular Tags


Ask Question