excel & lookup

Sheet 1 - This has a code column Sheet 2 - this also has a code column Expected result Sheet2 also has a column where in Codes Values are Yes and No values are mentioned So when I do Vlookup based on Matching Code Names I want to match it with the Code Values and return the results as Yes...

I have created a Vlookup formula on one of the columns on a workbook. This Vlookup will look for part numbers on the other Workbook and paste the ones that are matching and others that are not matching will showup as NA I want to change this formula in a way that. Anything that Matches should...

Hello All, I have something similar situation on my workbook. Sheet1 has large amount of data with Product name (column A) and current value (column D). There are some blank records in between too. Sheet2 has Product name (column A) and sold amount (column B). There are no blank records in...

I am trying to loop through my pivot table to copy the sum values to another sheet. The issue I am facing is, the row variables are dynamic and change when there is a data change, so when there is no variable D or S my loop does not run. Can anyone help me with how to make this work? The...

I have a spreadsheet that need to track the total sq ft active for each month/year until expiration based, when the contract expires I need it to fall off in the cell Property Sqft Expiration Date A 21,000 12/31/2021 B 522 1/15/2023...

Hi I am trying to get a total in column B. The total computation is as follows: 1. Row 1 has the 4 same dates with Set 1 to 4 in row 2. 2. The total is computed if there is at least 3 "Y" for a date. For the first guy, he has 4 Y in first day and 3 Y in 3rd day so it is 2 for the second guy, he...

I got data in sheet1 and sheet2, which i want to copy and paste in sheet3. That is already done. So next i want to match rows, by checking column C, D, E, H and I. The C and H column value is integer and the rest is text/strings. If two rows match, then i want to copy and paste one of the lines...

Hello, i would like to make a data input from two workbooks that is in the same path. The data input should be in the master workbook from those two files. The first sheet in the master workbook should just be empty as im going to make macro run buttons for later purpose. The data from the first...

Hello everyone I would love some help to develop some VBA code. But im very new to VBA. Hope someone can help me with it, and i know its a lot to implement. So its for private purpose and a "just for fun project". The project is that i want to two files in a path that i want to match with...

#Get data "Sheet 1" to "Sheet 2" in excel ( Check in Image , Sheet 1 many Spaces in there , So i Need "invoice Number list" on Sheet 2 (Auto Generated) how to possible get data as a list format, NOTE: SHEET 1 : *** So many Space in there*** SHEET 2...

I have an excel file that has 2 sheets. 1 for tracking services rendered and another with a list of customers and their fees per service. Tracking Sheet For each service, we manually enter a number for how many times the service was rendered. We then select the client from a drop-down list...

Autogenerate serial number according cell reference Number ???? I have try cell Reference : A2 =11 i try cell reference A2 to B3 , problem is B3 Cell value According Auto generate serial Number.

i need only one Column , how to remove unuse area in classics pivot table ????? Show me how to delete empty column formatting

@ How to show selected menu in slicer to other cell ??? (Like a Reference Indication) in pivot table ???? I have Try selection in slicer information reference to other cell , Above image like this yellow Highlight cell this reference

@ How to make One Dropdownlist , Including all table Column Cell Details Show ???? without Dependent Dropdownlist ??? How to show dropdownlist using different -different Columns data , And Add Included Single Dropdownlist ************************************************NOT USE DEPENDENT...

Hi All, Sorry not good with excel formula, can you help me construct formula how can I count how many duplicates we have in Column B per Name (Column A)? Sample result should be: Rose - 1 (2 Red) Joy - 1 (2 Purple) Angel - 2 (2 Blue & 2 Red)l

Hi, I'm trying to figure out a way to make daily performance tracking easier. I have a table X with dates, performance (ie. sales) and seller. Example below: Date Person A Person B 14.4.2021 100 200 15.4.2021 150 50 16.4.2021 250 100 Currently each person has to go and manually...

ok to start off with ,, thank for taking the time here to read this ive litterally been learning vla for 24-48 hours and im stuck with a few things i wondering if i could pick your brains to help soo.. ive attached a spreadsheet where im wanting to add a new line after pasting to my database...

In one sheet I have data in one row (Style Number, Column A) which has many duplicates, but every corresponding value of that (each) duplicate value has a unique value (Item Code, Column B). In sheet 2, I have got just Style Number (Column A). How can I match the Column A in both the sheets...