sheet5

Hello, This is my first post. I've tried searching this out without success. Probably because my VB skills are non-existent. Anyway, what I'm trying to accomplish is, I have a userform with a command button on sheet5. When the button is executed, I would like index/match sheet5 column A against...

Hi folks! I just created an account, because i need some help. I have lots of excel sheets. All are linked together. It is just a mess. So i am trying to visualize the flow of data through all sheets. I already made a table with all sheets and all dependencies. It looks like as follow...

I have a sheet that shows the results of data looked up in a table using the formula =IFERROR(INDEX(Sheet5!$A$2:$A$37,AGGREGATE(15,6,((ROW(Sheet5!$B$2:$B$37)-ROW(Sheet5!$B$2)+1))/((Sheet5!$B$2:$B$37=$B$3)),ROWS($A$1:A1))),"") Sheet5 contains a table that has A)Room, B)Person, C)Date...

I Have a list of items in Col A on sheet4 I need a macro to the items on sheet4 in Col A after the last row in Col A on Sheet5 if these items do not exist in Col A on Sheet5 For eg is Ste01 is in Col A on Sheet4 and exists in Col A on Sheet5 then do NOT copy. If MTT001 is in Col A on sheet4...

sheet5 https://i.stack.imgur.com/nbBHL.jpg sheet6 sheet7

I would like to make a macro to E-mail of Sheet5 or Sheet5 (A:1,J:300) to Sheet5 H5 (an e-mail address) in vba. Can you guide me in the right direction? I can make the macro I just don't know how to wright the code.

I would like to make a macro to E-mail of Sheet5 or Sheet5 (A:1,J:300) to Sheet5 H5 (an e-mail address) in vba. Can you guide me in the right direction? I can make the macro I just don't know how to wright the code.

Hello, I am working on code to move details on one sheet to another. I would like details from Sheet5 to populate Sheet7. For example, I would like Columns B-I to automatically populate columns B-I on Sheet7. I tried working on just one column ($E$7:E7 on sheet 5) to ($E$8:E8 on sheet7) with...

Good morning MrExcel Members. I'm requesting help on VBA code to populate TextBoxes based on what is entered into ComboBoxes. I have a combo box (TailNumber_cbo) I have three Text Boxes AircraftType_txt, EquipmentType_txt Color_txt) All three inside a Frame (Aircraft_fra) My...

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, I have a workbook where I have a sheet (sheet1) that contains document names in column A and a days until deadline in column J. In a sheet called sheet5 I have a IF function that says that if the "days until deadline" is over 0 but under 120 then the document name will be copied from the...

I’m really hoping someone may be able to help me with the following VBA problem: I have a data entry Userform with 21 textboxes which I’m using to collect the user’s details. In the first instance I would like the values (data) from all of the textboxes to be transferred to my workbook...