worksheet2

  1. Pinaceous

    ThisWorkbook Question

    Hi All, I'm trying to use a different code structure for the NAMED tab of "Tab_ONE" with the following: ThisWorkbook.Sheets("Tab_ONE").Range("B11:X180")) Is there anyway to restructure this to use the for example, Worksheet(2) in lieu of "Tab_ONE"?? Please let me know, if you should have...
  2. T

    Copying via formula

    Hi, I have worksheet1 where I have a list of items and this is where I add, delete or amend the item details, I use conditional formatting to highlight certain things. In worksheet2 I use a formula to get the data from each cell in worksheet1 (=worksheet1!A1 etc for each cell). Then in...
  3. A

    Dynamically Pulling Data between Worksheets

    Hello, I am trying to do a small pull of data between two worksheets but in an active manner, I'm hoping someone here might be able to figure this one out as I can't come up with a perfect solution. Sample Data on Worksheet1: On Worksheet2 I would like to pull anything that says 'Yes' in...
  4. E

    How to extract information?

    Hi, Can someone please help me with this doubt? I have in worksheet1 these columns: Product: A, B,C Code: 11111, 22222, 33333 Jan-19: 2, , 3 Feb-19: Mar-19:1,8,9 ... Dec-19:5, , In worksheet2, I have the same product and code information. I would like to get the last moth where it was a...
  5. R

    VLOOKUP maybe? Search a row of text in one worksheet by comparing from another worksheet

    Hi, I have worksheet1 with rows that contain a sentence. In another worksheet2 I have a table with Keywords that I want to look up in worksheet1 and then redefine them with worksheet2 table. I thought perhaps it would be an IF with VLOOKUP, but I'm not getting the expected result. For...
  6. K

    copy past (condition) and send to outlook with timer set on daily

    Hello, I want to solve my issue at work via excel VBA everyday at 15:45 PM Open an excel file workbook in my c://path/name file say file name is Andrew_daily error REFRESH the workbook Andrew_daily error to get the most updated information (it links up another excel data) in the excel...
  7. J

    Find if value already exists on separate worksheet, regardless of format (number, text, etc.)

    Example: Worksheet2, ColA, is a list of User IDs that are created via a formula that combines data from other cells in the same worksheet. Worksheet2, ColA, is a list of IDs for existing account holders. What I did: I created a vlookup formula to confirm whether or not the new ID that is...
  8. B

    VBA to add index/match with references to currently active sheet rather than absolute reference

    Hi everybody, I have the below index/match formula which works in looking up values from worksheet2 that are on worksheet1 and returning a final match. Problem is I'm looking to add this to some VBA which will create a large number of worksheets, so I need the formula to calculate based on, for...
  9. A

    Match cell contents with a table name

    Hi guys Is it possible to use VBA to achieve the following: Determine if cell "A1" on Worksheet1! = the name of a table on Worksheet2! If it does, perform an INDEX in Column 2 and MATCH in Column 3 of that table I basically want the code to perform something like this: IF A1 = A table...
  10. H

    INDEX/MATCH on 4 sets of criteria

    I am attempting to pull in select data from a Project Worksheet1 into an Expenditure Worksheet2 within the same workbook using 4 set of criteria in the Expenditure Worksheet2 The 4 sets of Match criteria found in the Expenditure Worksheet2 is as follows: FY-18 Project A1...
  11. M

    Index Match then Merge and Eliminate Duplicates

    Hello, I'm trying to write a Macro to match and display all the states and cities covered by a sales rep in 2 cells and remove any duplicate information at the same time. In my spread sheet terms: If the name in worksheet1 Cell A1, match the name in worksheet2 column C, then: display the...
  12. J

    VLOOKUP and MIN functions

    Example worksheets: I'm trying to resolve for Worksheet1 B2 - B4 I want to find the earliest transaction date in Worksheet2 for each UniqueID in Worksheet1 Column A and place the date in Worksheet1 Column B. There are only unique ID numbers in A Worksheet 1 Worksheet2 is a transaction table...

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