match value

  1. S

    Match value with other value in difference sheet

    Hi guys, Could you help me, please? I have a big data and many row. I have 2 sheet, sheet 1 have column name, netto and fee. Sheet 2 is like sheet 1. But field from sheet 1's not like sheet 2. Sheet 1 have data cell in netto, sheet 2 have data cell in fee. My expectation result if Neo A have...
  2. Z

    VBA to colour cells if they are equal to or greater than another worksheet cell value

    Hi All, Please could you help me. I am trying to loop through the rows in my worksheet and then if the cells in a column match a value in another worksheets cell then I need it to change to colour of the cell. My Main table has about 50 rows and the headers start in row 2. There are 23 Columns...
  3. R

    How to search for keywords in a column and return the values from the column next to the value found?

    Hello, I have the following Excel data and I would like to return the repeated values found when the user searches for keywords. It can be a formula and/or VBA code. To be considered: 1. Column A and B have fixed values. 2. Column C and D are the keywords that the user will enter (not...
  4. B

    Automatic Hyperlink between two rows based on matching content in field

    I have what would seem to me to be a simple request, unfortunately not for me. :eeek: I would like to write a VB script that will take the Value in Column A and find its match in Column B in the same excel sheet and create a dynamic hyperlink to it. I have 100s of values in Col A sorted in...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top