Excel Formula Help
Hi everyone again, so I am trying to pull data from one tab (DATA) to another tab (MRD ABC123, SLRD ABC123, etc..) there are examples in the first 2 tabs (MRD & SLRD ABC123) of how i am trying to pull this data over. I have tried formulas and have had some help on here as well to try some formulas but nothing is wanting to work. The data on the DATA tab is being copied and pasted from a Microsoft Forms. the columns i want to transfer the data to their perspective tabs is in Orange (Column F - R) Any help on this would be greatly appreciated. I have attached the spreadsheet belowAs any one found cool icons to use on a Custom Ribbon?
Hello Excellers, I just finished making a neat custom ribbon for an application, and I am wondering if anyone has found a cool and neat place to grab some icons for the button faces specially if in color. My ribbon looks nice, and most importantly it works as intended, but I am kind of thinking it could be more colorful. So far I only used the built-in stuff. Thanks for any hints. GiGi
Finding Possible Matches to a Solution
Hello Everyone, I'm wondering if anyone has any tricks or formulas that I can use to find any possible combination of numbers that will create the desired solutions I'm looking for. Take a look at the picture I uploaded for reference. If I have a list of data in column A, I will be looking for a given set of numbers that will create a sum that matches column C. I'm looking for a trick or formula that will return all possible combination of numbers that will sum up to equal Column C and then return those possible combinations in another column for me to see (for example like what you see in columns E, F, & G). Does anyone have any ideas on how or if this can be done? I would like to do this without the use of complicated macros or other codes if possible.I need to learn how to use the LET function in Excel...
Hello Excellers, I am using a complex If statement to figure out if a machine is ready to receive work. I need to check if the machine is online, or broken down, or off line for some reason or another, Has a Human worker to work on the machine, and on and on... I am thinking would a LET function help in making the IF function more accurate, and less complicated? I have not worked with the LET function, and I think I would like to learn about it. Any nice resources for examples and tutorials? Thanks in Advance! GiGi!Working with workbooks shared via Teams/Sharepoint
Hello Excellers, I need some insight on an issue that I am not sure what the source is... A) We sometimes share workbooks via Teams. You know when you are in a particular chat and next to the name of the chat at the top of the screen you see Shared and then you see Files button a bit below the Shared menu and when you click on that Files button you will see a list of what workbooks are shared. B) So I wrote some VBA code to download a copy to the Downloads folder like that: Dim RetVal As Long Dim SharePointFileURL As String Dim LocalDownloadPath As String Dim FileName As String RetVal = URLDownloadToFile(0, SharePointFileURL, LocalDownloadPath & FileName, 0, 0) If RetVal = 0 Then MsgBox "File successfully downloaded to: " & LocalDownloadPath & FileName, vbInformation This will message be replaced by the code we need to run... but for now I needed an indicator that it finished downloading. Else MsgBox "Failed to download the file. Please check the URL or your network connection.", vbExclamation End If So RetVal is = 0, and I do see the workbook in the \Downloads folder and it has a size of 4KB and the correct Date Modified time stamp, BUT When I try to open the workbook via the Excel desktop application I get the message: Excel cannot open the file "File name here" because the file format or file extension is not valid. Verify that the file is not corrupted and that the file extension matches the format of the file. The workbook should be 34KB in size and that 4KB file is not what I need??? Any ideas how to manage this, saving a workbook from a SharePoint / Teams file location to the computer so that we can run VBA code on it. GiGi
Excel help requested
Hi folks I am new to the forum but have been an Excel user for a good few years. I would appreciate some advice from experts. I have a spreadsheet with several worksheets on it. The first being the entries from bank statements. I would like to have the entries on this sheet automatically added to the respective worksheet as each company my Masonic lodge uses has a separate worksheet. For example gas etc. I’ve tried to attach the sheet but it doesn’t appear to be possible. Thank you in advance. steve
Excel Formula
Hi, I'm trying to figure out which formula (if any) to use in my workbook to make it more automated. I am needing to have a formula in worksheet 4, that will go to worksheet 1, locate the word "Thursday" in column B and return the corresponding date listed in column A. For more context, worksheet 1 has information for daily testing and worksheet 4 is a report that requires specific information for Thursdays only. I've been able to automate everything except for pulling the dates from worksheet 1. I've tried VLOOKUP, XLOOKUP, IF, IFS and I just can't figure it out, as well as spending many hours trying to research which formula(s) to use. Please let me know if more information is needed.
