sheet3

I can figure this out with 1 sheet, but I’m at a complete loss with an OR function. So I have a Name in Cell A1 on Sheet1. I want to see if that Name is in column A on Sheet2 or Sheet3 and return the text “Sheet2” if it’s on Sheet2 or the text “Sheet3” if found on Sheet3. Thanks!

I have seen many posts like similar to this but none seem to do what I need. I sure hope you can help. I would like to be able to populate sheet3 range I10 to I109 with alpha numeric values (never the same and may not have values for all 100 cells). Then have a macro that will search for an...

I have a list of numbers on sheet5 and another list of numbers on sheet3 and would like to have sheet3 be colored with a specific color if any of those numbers on sheet3 match sheet5. yellow for example, how would I do that?

Hi, Wonder if anyone can help, im trying to do this in VBA but im very new to it and I cant get it to work, i think maybe im pasting the codes into the wrong sheets etc. Basically i have a column (B) in sheet3 which has a list of addresses, the data in this column is taken from a column (A) in...

Since I've been hacking away at this syntax for over an hour... I figured it was time to give up and ask people smarter than me. I want to take the following standard SUM syntax: =SUM('Sheet3'!C5:C100) And, instead of manually specifying "Sheet3" in the formula I want to include a variable of...

Hi, I have for example 3 columns Column A Column B Column C SHEET1 SHEET2 SHEET3 SHEET2 SHEET3 SHEET4 SHEET3 SHEET4 SHEET4 I want the common entries amongst the 3 columns in a new column. The output should be Column D Sheet3 Sheet4 any help on this...

Hello! Thank you in advance for your time!! I need to generate a macro that creates a new worksheet, SUM values from each previous sheet done made and also define the number of sheets will be created. Besides I want the name of that new sheet be related to the result of the SUM e.g. On...

I have data on sheet3 on Columns A to M. The values are in Column K2 onwards I would like to extract the data to a separate sheet making up a certain value For eg if I want to find what items make of the value of say 2469147.72 on sheet3, I would like to be able to input this value in a...