Macro/Code to duplicate a range of formatted cells based on data

[nico67]

Hi,

I need help to figure out the following:

In the example below, first tab contains a range of formatted cells which I need to fill with the data from the second tab.

It will be perfect when adding a row of data in sheet 2 a new box with the formatted cells gets populated down in sheet 1.

My sample shows 2 lines of rows already populated but not the 3rd. I would like to avoid copy and paste the formatted cells as I don't know how many rows of data sheet 2 will contain.

Is it possible to do that, if yes could you please help me?

Thanks very much!

First tab
<style> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} @page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl63 {color:black; font-size:9.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:.5pt solid windowtext; border-right:none; border-bottom:none; border-left:none; background:silver; mso-pattern:black none;} .xl64 {color:black; font-size:9.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:.5pt solid windowtext; border-right:none; border-bottom:none; border-left:none; background:silver; mso-pattern:black none;} .xl65 {color:black; font-size:9.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:.5pt solid windowtext; border-right:none; border-bottom:none; border-left:.5pt solid windowtext; background:silver; mso-pattern:black none;} .xl66 {color:black; font-size:9.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:silver; mso-pattern:black none;} .xl67 {color:black; font-size:9.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; background:silver; mso-pattern:black none;} .xl68 {color:black; font-size:9.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:none; border-right:none; border-bottom:none; border-left:.5pt solid windowtext; background:silver; mso-pattern:black none;} .xl69 {color:black; font-size:9.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; background:silver; mso-pattern:black none;} .xl70 {vertical-align:top;} .xl71 {color:black; font-size:9.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext;} .xl72 {color:black; font-size:9.0pt; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:"\[ENG\]\[$-409\]d\\-mmm\\-yy\;\@"; text-align:left; vertical-align:top; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:none;} .xl73 {color:black; font-size:9.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:none;} .xl74 {color:black; font-size:9.0pt; font-family:"Arial Narrow", sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext;} .xl75 {mso-number-format:"\[ENG\]\[$-409\]d\\-mmm\\-yy\;\@"; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:none;} .xl76 {color:black; font-size:9.0pt; font-family:"Arial Narrow", sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:none;} .xl77 {color:black; font-size:9.0pt; font-family:"Arial Narrow", sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:.5pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none;} .xl78 {vertical-align:top; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:none;} .xl79 {color:black; font-size:9.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top;} .xl80 {text-align:left; vertical-align:top; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none;} .xl81 {vertical-align:top; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none;} .xl82 {color:black; font-size:9.0pt; font-family:"Arial Narrow", sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none;} .xl83 {color:black; font-size:9.0pt; font-family:"Arial Narrow", sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none;} .xl84 {text-align:left; vertical-align:top;} .xl85 {color:black; font-size:9.0pt; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:"\#\,\#\#0"; vertical-align:top; border-top:none; border-right:.5pt solid black; border-bottom:none; border-left:none;} .xl86 {color:black; font-size:9.0pt; font-family:Arial, sans-serif; mso-font-charset:0; vertical-align:top; border-top:none; border-right:none; border-bottom:none; border-left:.5pt solid black;} .xl87 {color:black; font-size:9.0pt; font-family:Arial, sans-serif; mso-font-charset:0; vertical-align:top; border-top:none; border-right:.5pt solid black; border-bottom:none; border-left:none;} .xl88 {color:black; font-size:9.0pt; font-family:"Arial Narrow", sans-serif; mso-font-charset:0; vertical-align:top; white-space:normal;} .xl89 {color:black; font-size:9.0pt; font-family:"Arial Narrow", sans-serif; mso-font-charset:0; vertical-align:top; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:none; white-space:normal;} .xl90 {color:black; font-size:9.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:silver; mso-pattern:black none; white-space:normal;} .xl91 {color:black; font-size:9.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:none; border-right:.5pt solid black; border-bottom:.5pt solid windowtext; border-left:none; background:silver; mso-pattern:black none; white-space:normal;} .xl92 {color:black; font-size:9.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:.5pt solid black; background:silver; mso-pattern:black none; white-space:normal;} .xl93 {color:black; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:.5pt solid black; white-space:normal;} .xl94 {color:black; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; white-space:normal;} .xl95 {color:black; font-size:9.0pt; font-family:"Arial Narrow", sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid black; border-left:none; background:silver; mso-pattern:black none;} .xl96 {color:black; font-size:9.0pt; font-family:"Arial Narrow", sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid black; border-left:.5pt solid black; background:silver; mso-pattern:black none;} .xl97 {color:black; font-size:9.0pt; font-family:"Arial Narrow", sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:.5pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:.5pt solid black; border-left:.5pt solid black; background:silver; mso-pattern:black none;} .xl98 {color:black; font-size:9.0pt; font-family:"Arial Narrow", sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; background:silver; mso-pattern:black none;} .xl99 {color:black; font-size:9.0pt; font-family:"Arial Narrow", sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:none; border-right:none; border-bottom:none; border-left:.5pt solid black; background:silver; mso-pattern:black none;} .xl100 {color:black; font-size:9.0pt; font-family:"Arial Narrow", sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:.5pt solid black; background:silver; mso-pattern:black none;} .xl101 {color:black; font-size:9.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:none; border-right:.5pt solid black; border-bottom:.5pt solid black; border-left:none; background:silver; mso-pattern:black none; white-space:normal;} .xl102 {color:black; font-size:9.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:none; border-right:.5pt solid black; border-bottom:.5pt solid black; border-left:.5pt solid black; background:silver; mso-pattern:black none; white-space:normal;} .xl103 {color:black; font-size:9.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:none; border-right:none; border-bottom:none; border-left:.5pt solid black; white-space:normal;} .xl104 {color:black; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:none; border-right:none; border-bottom:none; border-left:.5pt solid black; white-space:normal;} .xl105 {color:black; font-size:9.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border-top:.5pt solid black; border-right:.5pt solid black; border-bottom:.5pt solid black; border-left:none; background:silver; mso-pattern:black none; white-space:normal;} .xl106 {color:black; font-size:9.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:top; border:.5pt solid black; background:silver; mso-pattern:black none; white-space:normal;} --> </style>

Industry

ELT

Field

Ter

Scope

15

Total

12

Employees

Man

Action

MA

% Improvement

100

Type

Call

Area

Geo

Location

22

Source

Eng

Focus

ANP

Calls

12

Language

USD

Issues & Problem

CEO

ppl

DD

Currency

PJ

Obstacles/Comp

Go Ahead

Data

1

Paid From

FG

Comments

None

%

Half

Industry

CNT

Field

Gram

Scope

10

Total

10

Employees

Dir

Action

NY

% Improvement

112

Type

Ref

Area

Wall

Location

333

Source

Eng

Focus

None

Calls

33

Language

USD

Issues & Problem

None

ppl

Scad

Currency

PJ

Obstacles/Comp

None

Data

10

Paid From

DL

Comments

None

%

Full

<colgroup><col style="width:65pt" span="16" width="65"> </colgroup><tbody>
</tbody>

second tab

Field

Total

Improvement

Calls

ppl

Data

%

Scope

Employees

Type

Source

Language

Currency

Paid From

Action

Area

Focus

Issues & Problem

Obstacles/Comp

Comments

COMMENTS 2

Industry

Gram

10

112

333

33

Scad

10

Full

10

Dir

Ref

Eng

USD

PJ

DL

NY

Wall

None

None

None

None

ELT

Ter

12

100

22

12

DD

1

Half

15

Man

Call

Eng

USD

PJ

FG

MA

Geo

ANP

CEO

Go Ahead

None

CNT

DFR

15

110

25

15

EE

5

Full

155

Non

Rer

Eng

UST

HR

TYY

OH

All

NHY

UYT

Nogo

TT

NBV

<colgroup><col span="22"></colgroup><tbody>
</tbody>