exel

=XLOOKUP([@Item]&[@[Bin Number]],Item19&Bin_Number19,"@[Count19]","",1) =XLOOKUP("[@Item]='R19'!@Item19*'Calculate sheet'!@[Bin Number]=@'R19'!A3:A68",Item19,Count19,"",1) this only pulled the first instance of the same name I tried the above and a few other variations but could not get the...

Hello! Sounds complicated. But I hope someone can help me. I have never worked with macros function, and can't understand how to make it work to save myself. So i have these two sheets. This is Sheet1 Name Comment (empty for now) C1 C4 R71 This is Sheet2 Number Price Comment...

Hi, I have below code that is copying from a excel file into a report, the issue I'm trying to fix is with the 3 lines below, it is set to row 26 as this is usually where the data to be filled down is pasted but I need to change this to update dynamically if there is new data above it e.g. one...

Hi All, I am looking for a code that will help me copy a workbook and fill it with information from another workbook. i already wrote a code that creates a copy, now i need a code that it will take information from the source workbook put them into the workbook i just copied, i hope i have...

Hello all, I'm trying to figure out how to change the column range incrementally as the cell in column N is dragged down. I'm a little stuck. The highlighted cells per row should equal the value in column N. The range length stays consistent but moves one to the right as the row moves down...

Hello, How can you auto higlight selected field on userform? So basicly I need this line to be highlighted (Me.lstDatabase.TopIndex = Me.lstDatabase.ListCount - 1) ListBox1.BackColor = RGB(153, 153, 255) ??????

how to not copy a sheet with specific name please, thanks!

i need to know what is the toal of monthly payments i have made i have forgotten how to include a spreadsheet on this forum post! thanks all <colgroup><col style="mso-width-source:userset;mso-width-alt:2560;width:68pt" width="90"> <col...

Hello, I have big problem. I want to make a 1,2,3 biggest numbers but there is two simillar so exel write two same words, how should I write the formula? =INDEX(A4:A16;MATCH(LARGE(H6:H16;{1;2;3}); H4:H16; 0)) How should I correct this formula? If it need, i can add the photo. P.S. sorry for...

Hello all, Please help me with this. I have tried many vba and tutorials on youtube but with no any luck. I wanna add dynamic excel filter search box to existing exel tables. Can you please help with any tips?

Hello i have 1001 individuals in my dataset, i would like to assign randomly to each one "owner" and "non_owner". knowing that after the random assignement i should have 71% owner and 29% non-owner. is it possible with excel? thank you for your help

Hi all, I'm trying to include 2 lists for my Combox listing, but it's not working.... Here's my code and I hope someone here is able to help out Private Sub OptionButton1_Click() End Sub Private Sub OptionButton2_Click() End Sub Private Sub OptionButton3_Click() End Sub Private Sub...

This code has some syntax error but its generic I cant understand. Says For with no Next I have got an next in code it as I am new at this how can I Skip to next row if the row does not contain a number? For Each Nextcell In Range(InitialRow) If Not IsNumeric(Nextcell) Then...

I am creating a spreadsheet for users to punch in an out after they have completed a task. I need to ensure that these entries are honest. Is there a formula I can use that will ensure a user can only enter the current time in a given cell?