Hello! I am trying to create a code that after an autofilter, if there are multiple results then some type of inquiry pops up to allow the user to choose the best option. For example after an autoFilter the following results are showing:
Ms Excel TAKE OFF from
I would create some function to concatenate all the columns in a row to be put into a single cell, so that the user will see all of the information. Like so:
Ms Excel TAKE OFF from
Then they will choose which option is the best fit, and it would copy just the "material" column of the row they selected to be the best. So lets say they chose the second one then only the bolded part would be copied:
Ms Excel TAKE OFF from
Hopefully this makes sense.
Is something like that possible? If not does anyone have any suggestions on something I could do instead?
As of now I have my autofilter working if there is a single result, I'm just not sure how to do multiple is a "hands off" way.
Ms Excel TAKE OFF from
Spec | MOC | ITEM | Smaller | Bigger | RATING | ENDS | MATERIAL |
FB74 | FRP | Pipe (Notes 1, 2, 3) | 3.00 | 4.00 | 150 psi | Plain End | NOV Fiber Glass Systems, CL‐2030 Centricast Fiberglass Pipe, Vinyl Ester Resin with an internal 100‐mil Resin Liner, ASTM D‐2997, RTRP‐22BS‐4556 |
FB74 | FRP | Pipe (Notes 1, 2, 3) | 4.00 | 14.00 | 100 psi | Plain End (Butt Wrap) | NOV Fiber Glass Systems, F‐Chem FRP Pipe, Filament Wound, 100‐mil Vinyl Ester Resin Liner. |
FB74 | FRP | Pipe Support Cradle | 1.00 | 14.00 | N/A | N/A | NOV Fiber Glass Systems, Centricast Pipe Support Cradle/Wear Pad, Fig. 391. |
I would create some function to concatenate all the columns in a row to be put into a single cell, so that the user will see all of the information. Like so:
Ms Excel TAKE OFF from
Spec: FB74 MOC: FRP ITEM: Pipe (Notes 1, 2, 3) Smaller: 3 Bigger: 4 RATING: 150 psi ENDS: Plain End MATERIAL: NOV Fiber Glass Systems, CL‐2030 Centricast Fiberglass Pipe, Vinyl Ester Resin with an internal 100‐mil Resin Liner, ASTM D‐2997, RTRP‐22BS‐4556 |
Spec: FB74 MOC: FRP ITEM: Pipe (Notes 1, 2, 3) Smaller: 4 Bigger: 14 RATING: 100 psi ENDS: Plain End (Butt Wrap) MATERIAL: NOV Fiber Glass Systems, F‐Chem FRP Pipe, Filament Wound, 100‐mil Vinyl Ester Resin Liner. |
Spec: FB74 MOC: FRP ITEM: Pipe Support Cradle Smaller: 1 Bigger: 14 RATING: N/A ENDS: N/A MATERIAL: NOV Fiber Glass Systems, Centricast Pipe Support Cradle/Wear Pad, Fig. 391. |
Then they will choose which option is the best fit, and it would copy just the "material" column of the row they selected to be the best. So lets say they chose the second one then only the bolded part would be copied:
Ms Excel TAKE OFF from
Spec | MOC | ITEM | Smaller | Bigger | SIZE (NPS) | RATING | ENDS | MATERIAL |
FB74 | FRP | Pipe (Notes 1, 2, 3) | 3.00 | 4.00 | 3” to 4” (80mm to 100mm) | 150 psi | Plain End | NOV Fiber Glass Systems, CL‐2030 Centricast Fiberglass Pipe, Vinyl Ester Resin with an internal 100‐mil Resin Liner, ASTM D‐2997, RTRP‐22BS‐4556 |
FB74 | FRP | Pipe (Notes 1, 2, 3) | 4.00 | 14.00 | 4” to 14” (100mm to 350mm) *Forbranchconnections onF‐Chemheaders | 100 psi | Plain End (Butt Wrap) | NOV Fiber Glass Systems, F‐Chem FRP Pipe, Filament Wound, 100‐mil Vinyl Ester Resin Liner. |
FB74 | FRP | Pipe Support Cradle | 1.00 | 14.00 | 1” to 14” (25mm to 350mm) | N/A | N/A | NOV Fiber Glass Systems, Centricast Pipe Support Cradle/Wear Pad, Fig. 391. |
Is something like that possible? If not does anyone have any suggestions on something I could do instead?
As of now I have my autofilter working if there is a single result, I'm just not sure how to do multiple is a "hands off" way.