exel

  1. P

    How to get Multiple Vlookup values in to Dropdown list

    Dear All, I am trying to enter employees bank loan interest recover detailes in excel sheet ("3-2 Reimbursment" Sheet). For this purpose i use two sheets, one "3-2 Reimbursment" , other "Loan Details". in Account Details sheet, there are many emloyees details and some amployees may have more...
  2. S

    Formula for pulling the counts on items in i different locations but with same name

    =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...
  3. A

    if sheet1 columnB has matching value to sheet2 cellA(1) then copy sheet1 matched cellB to sheet2 cellH2. cycle for every cell

    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...
  4. O

    Copy from workbook and dynamically filldown data

    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...
  5. P

    vba code for filling out just copied excel file with info from another workbook

    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...
  6. F

    How to change column range incrementally as row cell is dragged down?

    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...
  7. C

    Auto Highlight selected field on userform

    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) ??????
  8. T

    don't copy sheet with specific name

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

    exel 2002 total accumulated payments

    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...
  10. S

    LARGE MATCH and INDEX formulas with dublicates

    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...
  11. L

    Adding dynamic excel filter search box to existing exel tables?

    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?
  12. M

    random assignment

    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
  13. F

    Combox list depend on OptionButton value

    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...
  14. G

    Excel Macro Just need to go next ROW if the value is not Numeric.

    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...
  15. J

    Data Validation and Current Time

    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?

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top