part1

Hi, I am trying to combine duplicate records but keep the data. I will provide an example below. Current Data: Part# text ------------------------ Part1 Sentence 1 Part1 Sentence 2 Part1 Sentence 3 Desired Outcome: Part # text ------------------- Part1 Sentence 1...

Hello everybody, I have two sheets with information in Excel, one (SheetB) where there are unique values like the one below: <tbody> Part1 Part2 Part3 Concat Value-1 Value-2 ASND WUX 45 ASNDWUX45 12000 0 PUGB SCA RL PUGBSCARL 5000 7000 ASND WUX 48 ASNDWUX48 0 5000 COMP ASQ N5...

HI Guys i want a script that is setup like the following...........i want to take starting position and do two things if the amount i have is less than the qty required make the row coloured and then subtract further qtys from the new starting position........ so for the below if my starting...

I'm just matching two cells and then copying and pasting from one worksheet to another, the copy line gives me an "Application Defined or Object Defined Error". Sub Add_Forecast_Data_to_Demand_Data() Dim totalrows1 As Long, totalrows2 As Long, iRow1 As Long, iRow2 As Long, part1 As String...

I have a 3 row spreadsheet that needs to be separated into multiple columns. Row 1 is the unique value. Row 2 will become the column name. Row 3 contains the data for the column. Ultimately will result in about 200 columns. Is there a good formula that would accomplish this? Thanks in advance...

Hi, I am trying to compile an array formula to perform following action: Here are input data: Prices in EUR for parts for months <tbody> Jan 2018 Feb 2018 Mar 2018 Apr 2018 PART1 1 2 2 4 PART2 2 3 4 5 PART3 3 4 5 6 </tbody> Structures (bill of material) of finished products <tbody>...

Hello, I am trying to figure out how to create a MAXIF Array function using duplicated value sums, and a known criteria value. Example: I have a shipment report that shows parts shipped down to a part and serial number. I need to summarize the data by part number showing only the largest...

Here is the current module I'm using. It works perfectly to save the workbook in the same folder as the Master Workbook. How ever I would like to save it to a sub-folder called "F:\O&M Consultant's Calculation\using "part1" as the variable\" & part1 & " O&M " & part2 & " .xlsm" Every time I...

Afternoon all stuck again if some can help me out, I have a userform with several text boxes on it ie a 7 x 3 grid I want to be able to populate the contents depending upon a variable for example if I have var = 3 string1 = "part1" string2 = "part2" so this would populate row 3 on my grid...