part1

  1. P

    Duplicate Multiple Record Combine

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

    Advanced Search VBA, search text within text and pull in values

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

    Help with Possible Script

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

    I don't understand why I'm getting this error

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

    Copy to column if cell matches certain value

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

    array formula to perform vlookup and sumproduct at once

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

    MAXIF Array using sum of duplicate value and known value

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

    Saving a Workbook in a new subfolder using VBA

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

    userform text box fill selected by a variable

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

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
Top