part

Hello. In cell A1 I'm receiving Customer names an their home town in form of huge HTML code. I need to extract Customer names in column A (A3:A600) and their home towns in column B (B3:B600). Part of HTML code for names is always the same: <div class="customName--1gBeC">J. Jones</div> Part...

Hello, I have a workbook with two worksheet. Please help me out with anything Vlookup/Index match, VBA etc.. On sheet1 I have column A= part number, column G=price and column M=location. On sheet2 I have column A= part number, column D= date, column M=price and column K=location. On...

Hello: In column A, I have 1,299 unique part numbers. The end user is going to choose one through a filter. I need cell B1 to equal that filtered number. I need this because I am doing an Indirect formula that needs just the chosen (filtered) part number, but because the filtered number is...

I already have a script that does most of the mumbo jumbo of what I need, however at the very end of that script, I want to add the part to rename part of some of my sheets to something else I have multiple template sheets and a master sheet within a workbook, those need to remain untouched...

Hi There - I need a working day calculation - but with a twist. Here is my example: A1 = 5/17/19 B1 = 8/1/19 C1 = _________ Part A: I need day #1 to be the first working day after 5/18/19. And then I need the last working day to be the day of B1. And I need to exclude a list of...

Hi, I'm trying to replicate a sumproduct formula in Power query editor within a custom column. Previously used working formula: =IF(SUMPRODUCT(($C$2:$C2=C2)*($E$2:$E2=E2))>1,0,1) I know sumproduct isn't used in power query, and after searching the net have attempted to use SumX but this...

I have a list with similar content to this: <colgroup><col style="mso-width-source:userset;mso-width-alt:2616;width:55pt" width="74"> <col style="mso-width-source:userset;mso-width-alt:3669;width:77pt" width="103"> <col style="mso-width-source:userset;mso-width-alt:1820;width:38pt"...

I have this if/then statement that doesn't run correctly. lbSL is a label on a userform that displays 5.5% and it should execute the first part of the if/then statement. However, it executes the second part of the if/then statement. My guess the code does not recognize the lbSl.Caption as a...

First I would like to thank everyone in advance for your help. My question is can you take a linked database on one sheet of a workbook, and have the data fill into cells by a search function? Example: UOM = Unit of Measure If i have a materiel part from a lumber company::: 2x4x16 Douglas...

Hi all, new to power Query and I need a solution to the above problem. basically I have a list of prices in 1 cell that are separated by a full stop "." E.g. 10990. 10450. 10190. 9990 And so on up to a max of 19 changes. I want to reverse these to show the below 9990. 10190. 10450. 10990...

Hello, Basically, I have over 1200 part numbers and I'm looking at an 8 quarter forecast. I am trying to get the below result that will be quick and efficient. Would like to be able to sort by quarter and etc. Any help will be greatly appreciated. Current: <tbody> Part Number QTR 1 QTR...

Hi - first time caller, long time listener. In my world, I have a long list of parts. What I want to do, is create a macro, that will when run, ask me what part # are you looking for. When found, it looks up the part and inserts the necessary # of rows. What I have is service kits that are...

I am not even sure if this is possible or not, but here it goes. I have two spreadsheets. Each spreadsheet lists a bunch of parts and part numbers. Spreadsheet A is the database of existing parts in the system. Spreadsheet B is a list of parts from a batch. In Spreadsheet B I want to be able...

I have a spreadsheet that will have x number of lines added to it. When all lines have been added, I have a button that inserts a signature 5 lines below the lowest part. The lowest part is a line at the bottom. Underneath the line, there is a textbox that will have notes written in it...

Hi Everyone I am pretty good at excel until it comes to layout.. I’m a Treasurer with a local soccer club and we have a snack shack that I am responsible for. I need to create a sheet where I can enter the total number of notes for each denomination but here is the tricky part I need to do it...

Sub findQTY() Dim pnum As Variant pnum = InputBox("Please Type in the part number") If dicQTY.exists(pnum) Then MsgBox dicQTY(pnum) Else MsgBox "No quantity available for this part number" End If End Sub the objective is to have the user enter a part number and it will either return the...

Hi All, I am using SUMIFS if the results in my list are met. I have either Y or N. I am wondering if I can add another drop down that would be ALL. I am looking to be able to filter our all the Y, N, or ALL if I want to sum all of the results. My formula is as follows; the bold is the part...

Good afternoon all, Can anyone please help with the following, I think its an ‘index/match’ formula – but I cannot understand any guides I can find online and it’s beyond a simple vlookup. I have sheets 1 in the same workbook, What I am trying to do is return a value in column C from sheet 2...

I'm trying to adjust a macro that was using .Select & Pasting pictures, but was throwing a fair amount of Run-time '1004' errors when trying to execute with an RPA tool. I know it's not the cleanest/most efficient, but I'm currently more concerned with the inconsistent results I'm getting. Some...

I have a list a part Numbers down column B. I want to know how many of those part numbers appear more than once in the list. Is there a formula for that? right now I have a count formula down a column and then count how many are not equal to one? I would rather just have a formula in one cell...