Get instant live Excel expert help to learn how to find range in Excel

Hi, I have two a range of ascending numbers from 1 to 70 in a column from d2:d71 and in column E a corresponding currency Value running from E2:E71 for example D55 = 54 and the value in E55 is £15.00 what I would like to do is type the sales achieved number a number in B1, for example if this number is 54 I want the formula to return the £15.00 in K54 in cell B2. could you please help

I am trying to return only non black values in a range.

I'm trying to do an if statement that looks up a range and returns a value

I used you guys yesterday and they gave me a solution that I can not get to work for me. I want to take a range and take all non blank values in it and list them in another range.

talked to 2 experts. First one i can not get the solution to work and the time expired on the second one. I need to take a range and list all non blank values init into another range

I have had 3 experts help me and havnt gotten a working solution yet for my issue. I am trying to move all the values that are not blank in a range and list them in another range with no blank cell.

I have a folder where new files are dumped everyday. I want to know the names of files present in the folder at the end of the day and each file's 'last modified by'/'last author'. I have a VB code which gives me just the file names but not the last modified by information. Can someone help with this? Here is the code Sub ListAllFile() Dim objFSO As Object Dim objFolder As Object Dim objFile As Object Dim objFileItem As Object Dim ws As Worksheet Dim lm As String Set objFSO = CreateObject("Scripting.FileSystemObject") Set ws = Worksheets.Add 'Get the folder object associated with the directory Set objFolder = objFSO.GetFolder("C:\Users\msinha\Desktop\Project DNA\New") ws.Cells(1, 1).Value = "FILE NAME " & objFolder.Name & "are:" r = Range("A65536").End(xlUp).Row + 1 'Loop through the Files collection For Each objFile In objFolder.Files ws.Cells(ws.UsedRange.Rows.Count + 1, 1).Value = objFile.Name Next 'Clean up! Set objFolder = Nothing Set objFile = Nothing Set objFSO = Nothing End Sub

I have a spreadsheet where there are tabs for each of my agents metrics. I want to create a vba that will pull from each tab and copy a specific range and then paste it into an outlook email addressed to that specific agent. Any thoughts?

Select the Cells B9, B15, B21, B23 and assign appropriate range names and Click B25 and use the newly created range names to create a formula to calculate the total house cost.

Enter values in D6:D15 from 1800 to 3600, step of 200; apply Blue font color and Comma style with zero decimal places In range D5:F15, create a one-variable data table with B7 as Column input cell