External Schedule integrate in to Excel

Tofik

Board Regular
Joined
Feb 4, 2021
Messages
114
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hallow everyone !
Guys how I can integrate Schedule Standard (STD) in my excel to automatically check 3 cells in my DB ?



This is original pdf file of Schedule Standard
1624433983183.png


This is my DB and I marked by color only that places which match with my DB, I want control those cells automatically because of human factor and mechanical mistakes.
I need only one Example how I can integrate this Schedule in my DB. By formula only because I don't know VBA properly.

TIE-IN Welding Log SD 2021 W (version 2).xlsx
BCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFASAVBABB
1Drawing №Revision NumberLineIsoTypeUnitServiceTrainMaterial ClassJoint TypeJointJoint SizeSpoolLocationSCHPipelenItem Code1Item Code2SubcontractorMat Grade1Mat Grade2AreaFit-Up DateHeat Number1Heat Number2WPSWelder1Welder2Welder3Welder4Date Of WeldWelding Report NumberVISUAL REPORT DATETHKVIS RESULTVIS DATE
2HS523217-66-PIP-ISO-0005-0001F0024-TP-660005-DA23-NIAG66TP0001DA23BWWS024SP01SHOP8018209631906050A234A105SHOP06.02.202110164931112019733110001PW-002N/AN/AN/A06.02.2021CON-PIP-12-T-S000106.02.20218.56ACC06.02.021
3HS523217-66-PIP-ISO-0003-0001F0024-TP-660005-DA23-NIAG66TP0001DA23BWWS024SP01SHOP8018209631906050A234A105SHOP06.02.202110164931112019733110001PW-002N/AN/AN/A06.02.2021CON-PIP-12-T-S000206.02.20218.56ACC06.02.021
Weld log
Cells with Conditional Formatting
CellConditionCell FormatStop If True
CD293:CJ294,CD301:CJ302,Z206:AA206,C204,BL205:BL206,BC217:BE217,O216:O217,U212:AE212,W231:AA231,AE231:AE234,Y234:AB235,AH235:BP235,AG220:BP220,AG211:BN211,W232:AB233,L359:CJ368,L2:CH2,L105:L106,L62:N64,L231:O234,L216:M217,L235:L236,L227:M230,C207:J210Cellcontains a blank value textNO


I just transform Schedule Standard (STD) which was in pdf to Excel.
std.xlsx
ABCDEFGHIJKLMNO
1Nominal pipe size mm/ inchOD mm2030STD4060XS80100120140160XXSShipping vol/CBM
215 1/221,32.77 1.272.77 1.273.73 1.623.73 1.624.78 1.957.47 2.550,0004
320 3/426,72.87 1.692.87 1.693.91 2.203.91 2.205.56 2.907.82 3.640,0007
425 133,43.38 2.503.38 2.504.55 3.244.55 3.246.35 4.249.09 5.450,0011
532 11/442,23.56 3.393.56 3.394.85 4.474.85 4.476.35 5.619.70 7.770,0017
640 11/248,33.68 4.053.68 4.055.08 5.415.08 5.417.14 7.2510.15 9.560,023
750 260,33.91 5.443.91 5.445.54 7.485.54 7.488.74 11.1111.07 13.440,036
865 21/2735.16 8.635.16 8.637.01 11.417.01 11.419.53 14.9214.02 20.390,0053
980 388,95.49 11.295.49 11.297.62 15.277.62 15.2711.13 21.3515.24 27.680,0079
1090 31/2101,65.74 13.575.74 13.578.08 18.638.08 18.63- -- -0,0103
11100 4114,36.02 16.076.02 16.078.56 22.328.56 22.3211.13 28.3213.49 33.5417.12 41.030,013
12125 5141,36.55 21.776.55 21.779.53 30.979.53 30.9712.70 40.2815.88 49.1119.05 57.430,0199
13150 6168,37.11 28.267.11 28.2610.97 42.5610.97 42.5614.27 54.2018.26 67.5621.95 79.220,028
14200 8219,16.35 33.317.04 36.818.18 42.558.18 42.5510.31 53.0812.70 64.6412.70 64.6415.09 75.9218.26 90.4420.62 100.9223.01 111.2722.23 107.920,048
15250 10273,16.35 41.777.80 51.039.27 60.319.27 60.3112.70 81.5512.70 81.5515.09 96.0118.26 114.7521.44 133.0625.40 155.1528.58 172.3325.40 155.150,074
16300 12323,96.35 49.738.38 65.209.53 73.8810.31 79.7314.27 108.9612.70 97.4617.48 132.0821.44 159.9125.40 186.9728.58 208.1433.32 238.7625.40 186.970,104
17350 14355,67.92 67.909.53 81.339.53 81.3311.13 94.5515.09 126.7112.70 107.3919.05 158.1023.83 194.9627.79 224.6531.75 253.5635.71 281.700,126
18400 16406,47.92 77.839.53 93.279.53 93.2712.70 123.3016.66 160.1212.70 123.3021.44 203.5326.19 245.5630.96 286.6436.53 333.1940.49 365.350,165
19450 18457,27.92 87.7111.13 122.389.53 105.1614.27 155.8019.05 205.7412.70 139.1523.88 254.5529.36 309.6234.93 363.5639.67 408.2645.24 459.370,209
20500 205089.53 117.1512.70 155.129.53 117.1515.09 183.4220.62 247.8312.70 155.1226.19 311.1732.54 381.5338.10 441.4944.45 508.1150.01 564.810,258
21550 22558,89.53 129.1312.70 171.099.53 129.13- -22.23 294.2512.70 171.0928.58 373.8334.93 451.4241.28 527.0247.63 600.6353.98 672.260,312
22600 24609,69.53 141.1214.27 209.649.53 141.1217.48 255.4124.61 355.2612.70 187.0630.96 442.0838.89 547.7146.02 640.0352.37 720.1559.54 808.220,372
23650 26660,412.70 202.72- -9.53 152.87- -12.70 202.720,436
24700 28711,212.70 218.6915.88 271.219.53 164.85- -12.70 218.690,505
25750 3076212.70 234.6715.88 292.189.53 176.84- -12.70 234.670,58
26800 32812,812.70 250.6415.88 312.159.53 188.8217.48 342.9112.70 250.640,66
27850 34863,612.70 266.6115.88 332.129.53 200.3117.48 364.9012.70 266.610,745
28900 36914,412.70 282.2715.88 351.709.53 212.5619.05 420.4212.70 282.270,836
29950 38965,29.53 224.5412.70 298.240,931
301000 4010169.53 236.5312.70 314.221,032
311050 421066,89.53 248.5212.70 330.191,138
321100 441117,89.53 260.5012.70 346.16SI Units (Metric) OD = mm Wall thickness = mm Weight = kg/m (plain end mass)1,249
331150 461168,49.53 272.2512.70 351.821,365
341200 481219,29.53 284.2412.70 377.791,486
page 1



Thanks guys.
 

Attachments

  • 1624433228381.png
    1624433228381.png
    94.9 KB · Views: 7

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Forum statistics

Threads
1,224,823
Messages
6,181,170
Members
453,021
Latest member
Justyna P

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
Back
Top