Search results
9 lip 2018 · I'm trying to write a macro where if there is a cell with the word "TOTAL" then it will input a dash in the cell below it. For example: In the case above, I would want a dash in cell F7 (note: there could be any number of columns, so it will always be row 7 but not always column F).
16 lut 2018 · I have two Excel sheets and I need to copy values from one to the other. Sheet 1: Contains ID´s in one column and Data in another, which I want to have in Sheet 2 later on. Sheet 2: Contains the same ID´s and has to be extended with the corresponding Data values from Sheet 1.
18 lut 2022 · I would like to compare 2 different sheets with a macro, based on values. I try to explain better. For example i have 4 columns of datas like: B6:B35 , C6:C57 , D6:D165 , F6:F234 in Sheet1. and a single column of datas like:
5 gru 2022 · The VLOOKUP and XLOOKUP functions in Excel are useful functions that allow us to search for a matching value in a range and return a corresponding value from another column. These functions can be used directly in a formula in Excel, or can be using in VBA Coding with the WorksheetFunction method.
21 sty 2022 · In this article. Returns the relative position of an item in an array that matches a specified value in a specified order. Use Match instead of one of the Lookup functions when you need the position of an item in a range instead of the item itself.
25 lut 2019 · My goal is to find the cells where the "Dates" are the same and where "Away or Home Club" matches "Organization", to ultimately find the location. I have two excel sheets and I need to find the rows which are comparable. I have a "Date" column that needs to be an exact match on both sheets.
7 lip 2020 · I am trying to create a macro that loops through the range in Sheet2 and finds a match on the range of headers in Sheet1, when it finds the match the values of the column with the matched header in Sheet 1 are copied in column F of Sheet2. I tried to use the worksheetfunction.match method, but then couldn't find a way to copy the right data:
