Get instant live Excel expert help to learn how to use Find function in Excel?

have a workbook that has 4 worksheets all of which have dates on row 5, stating at column D. In the cell next to the date the person will put either 'ET','LT','EG','1ET', '2LT' or they will leave it blank. I am reading on how VBA works at the moment but I have just started so very new to this. I have this so far but this is probably totally wrong Sub test() Dim summarySheet As Worksheet Dim sh As Worksheet Dim j As Integer 'change "Summary" to the sheet name that is true for you' Set summarySheet = ThisWorkbook.Worksheets("Summary") 'number of first row where need to paste in summary sheet' j = 2 'loop throught all sheets' For Each sh In ThisWorkbook.Worksheets If sh.Name <> summarySheet.Name Then summarySheet.Range("B" & j & ":AF" & j).Value = _ sh.Range("D5:AH5").Value j = j + 1 End If Next End Sub It displays all the sheets data, but what I need is if there is either ET or LT entered in row 5 next to the date then it adds the corresponding data from row 37 into a summary sheet. If it's just the number then it is to skip that and find the next ET or LT

Ex-3 I need VBA to find all the ET or LT and if that exists then it to copy the what ever is in row 37 so in team 1 sheet it has 4 ET so I would need to n the summary sheet under 4 ET to show 2

I have a workbook that has 4 worksheets all of which have dates on row 5, stating at column D. In the cell next to the date the person will put either 'ET','LT','EG','1ET', '2LT' or they will leave it blank. It displays all the sheets data, but what I need is if there is either ET or LT entered in row 5 next to the date then it adds the corresponding data from row 37 into a summary sheet. If it's just the number then it is to skip that and find the next ET or LT. I need this to change the summary automatically without a command button or running the macro manually.(if possible)

I have a specific number (let's say 20) and I want people to guess what that number is. Some might say 10 and some might say 40. I want to find who is the closest and the furthest away (negative and positive shouldn't matter). How do I do this?

Hi... I am creating a spreadsheet that contains a list with the names of real estate agents and their clients (in pairs). For example: Column A Column B Agent Name: Agent 1 Client Name: Client 2 I wrote a formula that populates the names by referencing a list of names in Sheet2. For example: Column A Column B Agent 1 Client 1 Agent 2 Client 2 Agent 3 Client 3 Agent 4 Client 4 My formula to populate the Agent Name looks like this: =Sheet2!A1 My formula to populate the Client Name looks like this: =Sheet2!B1 The problem is, I have dozens of places in my spreadsheet where the Agent/Client names appear (in no particular order/pattern). It would save me a ton of time to be able to just copy/paste the formula where needed, and the formula pulled Agent/Client names from the next row (rather than the row that I pasted into). Is there any way to write a formula to do this? I've searched all over the internet and I can't find a good example of what I'm looking to do.

Hi need to compare 3 columns to find mismatch data among all 3

need help to find out what is wrong with this formula IF(AND(B11="20-29",D11="VO2max",E11="FEMALE"),VLOOKUP(F11,$R$78:$T$82,3,TRUE),""

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?

What I need to do is look in one column and find the duplicates then where the duplicates are found go to a second column and find the number and copy that number to all cells that the duplicates are found.

I spoke recently with someone named expert 12 who was going to bring in a VBA expert to help. Here is a sample of the spreadsheet. What I need this to do is tell excel that when a number is identical in the C column to go to the S column, find the number in S for that duplicate group of C and make all the numbers in S for the duplicate group of C the same as the number found in S. you can see that C3, C4, and C5 have the same number so S3, S4, and S5 are the same number. If you look at C46, C47, C48, C49, C50 and C51 then look at the S column for the same rows I would need it to put the number found in S48 and S49 into S46, S47, S50 and S51. I would then need to find the next duplicate group of C and do the same thing. Finally Column T needs to repeat the same process as S. A mess I know