dlc

I want to copy data from Sheet1 to Sheet2 based on headers in two sheets. The following code works great when both sheets’ headers are in first row. My question is if header in Sheet2 is in row 8, then how would my code be? thank you. Sub CopyData() Dim sws As Worksheet, dws As Worksheet Dim...

<tbody> from To side Type 0 10 LHS DLC 15 25 LHS DLC 8 16 RHS DLC 2 8 LHS PQC 20 25 LHS PQC 10 12 RHS PQC </tbody> <tbody> PQC LHS DLC LHS Chainage 0 2 4 6 8 10 12 14 16 18 20 22 24 26 28 30 32 DLC LHS PQC LHS...

<colgroup><col span="4"></colgroup><tbody> Road Work Completed <tbody> From To Side Item 0 10 LHS DLC 18 20 LHS DLC 8 14 RHS DLC 18 26 RHS DLC 0 8 LHS PQC 8 12 RHS PQC 20 26 RHS PQC </tbody> Base of this data I want to draw colour Bar chart / Progress chart as shown in...

Hi, I have various data in column C on my sheet. Here are a couple of examples: NESC DLC GST Esp Honduras 12Cap 6x72g QW NESCAFE DLC GST LtMac 16Cap 6x194.4g QW Most of the data is different but the 12Cap & 16Cap are always there and it's the last entry in column C I am after. I was...