worksheet2

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

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

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

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

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

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

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

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

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

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

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

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