macro vlookup if replace

This Week's Hot Topics

• Dynamic cell and sorting

  • Started by Polanskiman
  • Nov 15, 2020
  • Replies: 31

  So here is the deal. I need that cell in E4 to be dynamic because the "Description" column on the Excel table is supposed to be sortable. By...
• How do I get combobox to get a cell number then link it to a selection from a checkbox in Excel?

  • Started by Ayugma
  • Nov 20, 2020
  • Replies: 31

  I have no idea how to really implement this. So I have 5 checkboxes, all of which are parts to a machine. So, a user will be able to select as...
• VBA code works on works desktop but not on my own laptop

  • Started by Monojono
  • Nov 20, 2020
  • Replies: 30

  Hello Readers and hopefully problem solvers, I have a large amount of coding across my workbook that works fine on my works desktop. However, on...
• Formulas referencing Pay Dates in year

  • Started by rishijain11
  • Saturday at 2:50 PM
  • Replies: 27

  Hi, I'm trying to build out this excel file to keep track of my finances. I could use some help with several formulas revolving around the pay...
• Sorting key

  • Started by dpaton05
  • Nov 15, 2020
  • Replies: 25

  When you are sorting using range.sort method, one of the parameters is Key. If I want to sort by column A, with the header being in row 3 and the...
• Copy Range of Cells And Paste Until Last Row

  • Started by Unexpc
  • Sunday at 12:11 PM
  • Replies: 21

  Hi guys i have a page in range A41:H74 and i want copy this page and paste until last row of excel sheet. does any vba code to do this?