loop through specific sheets and copy entire row into one master sheet if data is in column

O

Omer104

New Member
Joined
Oct 5, 2015
Messages
42
Office Version
  1. 365
Dear VBA wizards,

Can someone please help me – I have been going through this for a while

I have about 25 sheets in total in an excel file of which 10 sheets (one tab is called is AGV, one other tab is AGR etc) has some data and I would like to copy the entire row in each of these sheets if it has the text “new instrument” in col S, in these 10 sheets there are a lot of rows around 2000

This loop macro would collate all these rows in a sheet called “new instrument”

Can someone please help ?

Thanks a lot,
 
Sort by date Sort by votes
Hey Yongle,

Headers on Row 4
I can add a filter on Row 4 and on column S New instrument is in the dropdown list,
Data starts on Row 5
 
Upvote 0

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
If headers are in row 4, amend these 2 lines
Code: 
.Range("A[COLOR="#FF0000"]4[/COLOR]:ZZ9999").AutoFilter Field:=19, Criteria1:="*new instrument*"
.Rows("[COLOR="#FF0000"]5[/COLOR]:9999").SpecialCells(xlCellTypeVisible).Copy Ws.Range("A" & Rows.Count).End(xlUp).Offset(1)
 
Last edited:
Upvote 0
I assume you did not like my answer in Post 4 since you said nothing about my code.
 
Upvote 0
ah so sorry! I did respond but it didnt post!

I ran it but it keeps crashing at

.Offset(1).Resize(.Rows.Count - 1).SpecialCells(xlCellTypeVisible).EntireRow.Copy Sheets("new instrument").Rows(Lastrowa)

Application defined or object defined error
 
Upvote 0
did you test amendment suggested in post#12 ?
 
Upvote 0
I inadvertently reverted to the previous code in post#12
Apologies for that..:oops:
Try

Code: 
 .Range("A4:ZZ9999").AutoFilter Field:=19, Criteria1:="New Instrument"
 
Last edited:
Upvote 0
Here is what I am using
- the original macro amended as above (also amended the header row to be copied)

Code: 
Sub NewInstrument()
    Dim Ws As Worksheet, w As Variant
                                            'Const List = "AGV,AGR,XX3,XX4,XX5,XX6,XX7,XX8,XX9,X10"
    Const List = "[COLOR=#ff0000]AGV[/COLOR]"  'for testing just one sheet
    Application.ScreenUpdating = False
    On Error Resume Next
    Set Ws = Sheets.Add(before:=Sheets(1))
    Ws.Name = "new instrument"
    For Each w In Split(List, ",")
        With Sheets(w)
            .ShowAllData
            .Range("A[COLOR=#ff0000]4[/COLOR]:ZZ9999").AutoFilter Field:=19, Criteria1:="[COLOR=#ff0000]New instrument[/COLOR]"
            .Rows("[COLOR=#ff0000]5[/COLOR]:9999").SpecialCells(xlCellTypeVisible).Copy Ws.Range("A" & Rows.Count).End(xlUp).Offset(1)
            .Rows([COLOR=#ff0000]4[/COLOR]).Copy Ws.Range("A1")
            .ShowAllData
        End With
    Next w
End Sub

Sheet AGV

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]
A​
[/th][th]
B​
[/th][th]
C​
[/th][th]
D​
[/th][th]
E​
[/th][th]
F​
[/th][th]
G​
[/th][th]
H​
[/th][th]
I​
[/th][th]
J​
[/th][th]
K​
[/th][th]
L​
[/th][th]
M​
[/th][th]
N​
[/th][th]
O​
[/th][th]
P​
[/th][th]
Q​
[/th][th]
R​
[/th][th]
S​
[/th][th]
T​
[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
1​
[/td][td]Some[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
2​
[/td][td]random[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
3​
[/td][td]text[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
4​
[/td][td]H01[/td][td]H02[/td][td]H03[/td][td]H04[/td][td]H05[/td][td]H06[/td][td]H07[/td][td]H08[/td][td]H09[/td][td]H10[/td][td]H11[/td][td]H12[/td][td]H13[/td][td]H14[/td][td]H15[/td][td]H16[/td][td]H17[/td][td]H18[/td][td]H19[/td][td]H20[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
5​
[/td][td]Data01[/td][td]
0​
[/td][td]
3​
[/td][td]
0​
[/td][td]
3​
[/td][td]
7​
[/td][td]
7​
[/td][td]
3​
[/td][td]
8​
[/td][td]
1​
[/td][td]
1​
[/td][td]
2​
[/td][td]
5​
[/td][td]
4​
[/td][td]
6​
[/td][td]
8​
[/td][td]
5​
[/td][td]
1​
[/td][td][/td][td]
4​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
6​
[/td][td]Data02[/td][td]
3​
[/td][td]
3​
[/td][td]
4​
[/td][td]
7​
[/td][td]
2​
[/td][td]
0​
[/td][td]
6​
[/td][td]
5​
[/td][td]
9​
[/td][td]
3​
[/td][td]
8​
[/td][td]
2​
[/td][td]
4​
[/td][td]
5​
[/td][td]
5​
[/td][td]
4​
[/td][td]
5​
[/td][td]New Instrument[/td][td]
6​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
7​
[/td][td]Data03[/td][td]
0​
[/td][td]
2​
[/td][td]
7​
[/td][td]
7​
[/td][td]
5​
[/td][td]
5​
[/td][td]
5​
[/td][td]
4​
[/td][td]
6​
[/td][td]
4​
[/td][td]
7​
[/td][td]
7​
[/td][td]
1​
[/td][td]
5​
[/td][td]
4​
[/td][td]
9​
[/td][td]
5​
[/td][td]New Instrument[/td][td]
5​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
8​
[/td][td]Data04[/td][td]
4​
[/td][td]
8​
[/td][td]
8​
[/td][td]
4​
[/td][td]
6​
[/td][td]
3​
[/td][td]
2​
[/td][td]
9​
[/td][td]
6​
[/td][td]
4​
[/td][td]
1​
[/td][td]
7​
[/td][td]
7​
[/td][td]
4​
[/td][td]
9​
[/td][td]
5​
[/td][td]
4​
[/td][td][/td][td]
4​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
9​
[/td][td]Data05[/td][td]
8​
[/td][td]
0​
[/td][td]
4​
[/td][td]
0​
[/td][td]
0​
[/td][td]
5​
[/td][td]
2​
[/td][td]
1​
[/td][td]
6​
[/td][td]
8​
[/td][td]
6​
[/td][td]
9​
[/td][td]
9​
[/td][td]
8​
[/td][td]
0​
[/td][td]
4​
[/td][td]
5​
[/td][td]New Instrument[/td][td]
1​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
10​
[/td][td]Data06[/td][td]
6​
[/td][td]
0​
[/td][td]
2​
[/td][td]
3​
[/td][td]
6​
[/td][td]
8​
[/td][td]
2​
[/td][td]
3​
[/td][td]
9​
[/td][td]
3​
[/td][td]
4​
[/td][td]
5​
[/td][td]
9​
[/td][td]
8​
[/td][td]
9​
[/td][td]
3​
[/td][td]
6​
[/td][td]New Instrument[/td][td]
1​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
11​
[/td][td]Data07[/td][td]
4​
[/td][td]
4​
[/td][td]
7​
[/td][td]
7​
[/td][td]
5​
[/td][td]
0​
[/td][td]
7​
[/td][td]
0​
[/td][td]
9​
[/td][td]
3​
[/td][td]
9​
[/td][td]
5​
[/td][td]
3​
[/td][td]
9​
[/td][td]
4​
[/td][td]
3​
[/td][td]
1​
[/td][td][/td][td]
7​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
12​
[/td][td]Data08[/td][td]
9​
[/td][td]
0​
[/td][td]
6​
[/td][td]
3​
[/td][td]
4​
[/td][td]
6​
[/td][td]
7​
[/td][td]
8​
[/td][td]
2​
[/td][td]
9​
[/td][td]
0​
[/td][td]
1​
[/td][td]
5​
[/td][td]
8​
[/td][td]
3​
[/td][td]
4​
[/td][td]
5​
[/td][td]New Instrument[/td][td]
1​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
13​
[/td][td]Data09[/td][td]
5​
[/td][td]
5​
[/td][td]
0​
[/td][td]
1​
[/td][td]
5​
[/td][td]
9​
[/td][td]
0​
[/td][td]
0​
[/td][td]
1​
[/td][td]
4​
[/td][td]
7​
[/td][td]
1​
[/td][td]
9​
[/td][td]
0​
[/td][td]
2​
[/td][td]
0​
[/td][td]
1​
[/td][td][/td][td]
5​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
14​
[/td][td]Data10[/td][td]
9​
[/td][td]
4​
[/td][td]
7​
[/td][td]
2​
[/td][td]
9​
[/td][td]
1​
[/td][td]
4​
[/td][td]
8​
[/td][td]
7​
[/td][td]
4​
[/td][td]
2​
[/td][td]
9​
[/td][td]
0​
[/td][td]
9​
[/td][td]
8​
[/td][td]
0​
[/td][td]
1​
[/td][td][/td][td]
9​
[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: AGV[/td][/tr][/table]

Sheet "new instrument"

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]
A​
[/th][th]
B​
[/th][th]
C​
[/th][th]
D​
[/th][th]
E​
[/th][th]
F​
[/th][th]
G​
[/th][th]
H​
[/th][th]
I​
[/th][th]
J​
[/th][th]
K​
[/th][th]
L​
[/th][th]
M​
[/th][th]
N​
[/th][th]
O​
[/th][th]
P​
[/th][th]
Q​
[/th][th]
R​
[/th][th]
S​
[/th][th]
T​
[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
1​
[/td][td]H01[/td][td]H02[/td][td]H03[/td][td]H04[/td][td]H05[/td][td]H06[/td][td]H07[/td][td]H08[/td][td]H09[/td][td]H10[/td][td]H11[/td][td]H12[/td][td]H13[/td][td]H14[/td][td]H15[/td][td]H16[/td][td]H17[/td][td]H18[/td][td]H19[/td][td]H20[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
2​
[/td][td]Data02[/td][td]
3​
[/td][td]
3​
[/td][td]
4​
[/td][td]
7​
[/td][td]
2​
[/td][td]
0​
[/td][td]
6​
[/td][td]
5​
[/td][td]
9​
[/td][td]
3​
[/td][td]
8​
[/td][td]
2​
[/td][td]
4​
[/td][td]
5​
[/td][td]
5​
[/td][td]
4​
[/td][td]
5​
[/td][td]New Instrument[/td][td]
6​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
3​
[/td][td]Data03[/td][td]
0​
[/td][td]
2​
[/td][td]
7​
[/td][td]
7​
[/td][td]
5​
[/td][td]
5​
[/td][td]
5​
[/td][td]
4​
[/td][td]
6​
[/td][td]
4​
[/td][td]
7​
[/td][td]
7​
[/td][td]
1​
[/td][td]
5​
[/td][td]
4​
[/td][td]
9​
[/td][td]
5​
[/td][td]New Instrument[/td][td]
5​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
4​
[/td][td]Data05[/td][td]
8​
[/td][td]
0​
[/td][td]
4​
[/td][td]
0​
[/td][td]
0​
[/td][td]
5​
[/td][td]
2​
[/td][td]
1​
[/td][td]
6​
[/td][td]
8​
[/td][td]
6​
[/td][td]
9​
[/td][td]
9​
[/td][td]
8​
[/td][td]
0​
[/td][td]
4​
[/td][td]
5​
[/td][td]New Instrument[/td][td]
1​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
5​
[/td][td]Data06[/td][td]
6​
[/td][td]
0​
[/td][td]
2​
[/td][td]
3​
[/td][td]
6​
[/td][td]
8​
[/td][td]
2​
[/td][td]
3​
[/td][td]
9​
[/td][td]
3​
[/td][td]
4​
[/td][td]
5​
[/td][td]
9​
[/td][td]
8​
[/td][td]
9​
[/td][td]
3​
[/td][td]
6​
[/td][td]New Instrument[/td][td]
1​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
6​
[/td][td]Data08[/td][td]
9​
[/td][td]
0​
[/td][td]
6​
[/td][td]
3​
[/td][td]
4​
[/td][td]
6​
[/td][td]
7​
[/td][td]
8​
[/td][td]
2​
[/td][td]
9​
[/td][td]
0​
[/td][td]
1​
[/td][td]
5​
[/td][td]
8​
[/td][td]
3​
[/td][td]
4​
[/td][td]
5​
[/td][td]New Instrument[/td][td]
1​
[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: new instrument[/td][/tr][/table]





Below is the amended macr
 
Upvote 0
Yongle said:
Here is what I am using
- the original macro amended as above (also amended the header row to be copied)

Code: 
Sub NewInstrument()
    Dim Ws As Worksheet, w As Variant
                                            'Const List = "AGV,AGR,XX3,XX4,XX5,XX6,XX7,XX8,XX9,X10"
    Const List = "[COLOR=#ff0000]AGV[/COLOR]"  'for testing just one sheet
    Application.ScreenUpdating = False
    On Error Resume Next
    Set Ws = Sheets.Add(before:=Sheets(1))
    Ws.Name = "new instrument"
    For Each w In Split(List, ",")
        With Sheets(w)
            .ShowAllData
            .Range("A[COLOR=#ff0000]4[/COLOR]:ZZ9999").AutoFilter Field:=19, Criteria1:="[COLOR=#ff0000]New instrument[/COLOR]"
            .Rows("[COLOR=#ff0000]5[/COLOR]:9999").SpecialCells(xlCellTypeVisible).Copy Ws.Range("A" & Rows.Count).End(xlUp).Offset(1)
            .Rows([COLOR=#ff0000]4[/COLOR]).Copy Ws.Range("A1")
            .ShowAllData
        End With
    Next w
End Sub

Sheet AGV

Excel 2016 (Windows) 32 bit
[TABLE="class: head"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[TH][/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]A[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]B[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]C[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]D[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]E[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]F[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]G[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]H[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]I[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]J[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]K[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]L[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]M[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]N[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]O[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]P[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Q[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]R[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]S[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]T[/COLOR]​
[/TH]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]1[/COLOR]​
[/TD]
[TD]Some[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]2[/COLOR]​
[/TD]
[TD]random[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]3[/COLOR]​
[/TD]
[TD]text[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]4[/COLOR]​
[/TD]
[TD]H01[/TD]
[TD]H02[/TD]
[TD]H03[/TD]
[TD]H04[/TD]
[TD]H05[/TD]
[TD]H06[/TD]
[TD]H07[/TD]
[TD]H08[/TD]
[TD]H09[/TD]
[TD]H10[/TD]
[TD]H11[/TD]
[TD]H12[/TD]
[TD]H13[/TD]
[TD]H14[/TD]
[TD]H15[/TD]
[TD]H16[/TD]
[TD]H17[/TD]
[TD]H18[/TD]
[TD]H19[/TD]
[TD]H20[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]5[/COLOR]​
[/TD]
[TD]Data01[/TD]
[TD]
0​
[/TD]
[TD]
3​
[/TD]
[TD]
0​
[/TD]
[TD]
3​
[/TD]
[TD]
7​
[/TD]
[TD]
7​
[/TD]
[TD]
3​
[/TD]
[TD]
8​
[/TD]
[TD]
1​
[/TD]
[TD]
1​
[/TD]
[TD]
2​
[/TD]
[TD]
5​
[/TD]
[TD]
4​
[/TD]
[TD]
6​
[/TD]
[TD]
8​
[/TD]
[TD]
5​
[/TD]
[TD]
1​
[/TD]
[TD][/TD]
[TD]
4​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]6[/COLOR]​
[/TD]
[TD]Data02[/TD]
[TD]
3​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
7​
[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
6​
[/TD]
[TD]
5​
[/TD]
[TD]
9​
[/TD]
[TD]
3​
[/TD]
[TD]
8​
[/TD]
[TD]
2​
[/TD]
[TD]
4​
[/TD]
[TD]
5​
[/TD]
[TD]
5​
[/TD]
[TD]
4​
[/TD]
[TD]
5​
[/TD]
[TD]New Instrument[/TD]
[TD]
6​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]7[/COLOR]​
[/TD]
[TD]Data03[/TD]
[TD]
0​
[/TD]
[TD]
2​
[/TD]
[TD]
7​
[/TD]
[TD]
7​
[/TD]
[TD]
5​
[/TD]
[TD]
5​
[/TD]
[TD]
5​
[/TD]
[TD]
4​
[/TD]
[TD]
6​
[/TD]
[TD]
4​
[/TD]
[TD]
7​
[/TD]
[TD]
7​
[/TD]
[TD]
1​
[/TD]
[TD]
5​
[/TD]
[TD]
4​
[/TD]
[TD]
9​
[/TD]
[TD]
5​
[/TD]
[TD]New Instrument[/TD]
[TD]
5​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]8[/COLOR]​
[/TD]
[TD]Data04[/TD]
[TD]
4​
[/TD]
[TD]
8​
[/TD]
[TD]
8​
[/TD]
[TD]
4​
[/TD]
[TD]
6​
[/TD]
[TD]
3​
[/TD]
[TD]
2​
[/TD]
[TD]
9​
[/TD]
[TD]
6​
[/TD]
[TD]
4​
[/TD]
[TD]
1​
[/TD]
[TD]
7​
[/TD]
[TD]
7​
[/TD]
[TD]
4​
[/TD]
[TD]
9​
[/TD]
[TD]
5​
[/TD]
[TD]
4​
[/TD]
[TD][/TD]
[TD]
4​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]9[/COLOR]​
[/TD]
[TD]Data05[/TD]
[TD]
8​
[/TD]
[TD]
0​
[/TD]
[TD]
4​
[/TD]
[TD]
0​
[/TD]
[TD]
0​
[/TD]
[TD]
5​
[/TD]
[TD]
2​
[/TD]
[TD]
1​
[/TD]
[TD]
6​
[/TD]
[TD]
8​
[/TD]
[TD]
6​
[/TD]
[TD]
9​
[/TD]
[TD]
9​
[/TD]
[TD]
8​
[/TD]
[TD]
0​
[/TD]
[TD]
4​
[/TD]
[TD]
5​
[/TD]
[TD]New Instrument[/TD]
[TD]
1​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]10[/COLOR]​
[/TD]
[TD]Data06[/TD]
[TD]
6​
[/TD]
[TD]
0​
[/TD]
[TD]
2​
[/TD]
[TD]
3​
[/TD]
[TD]
6​
[/TD]
[TD]
8​
[/TD]
[TD]
2​
[/TD]
[TD]
3​
[/TD]
[TD]
9​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
5​
[/TD]
[TD]
9​
[/TD]
[TD]
8​
[/TD]
[TD]
9​
[/TD]
[TD]
3​
[/TD]
[TD]
6​
[/TD]
[TD]New Instrument[/TD]
[TD]
1​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]11[/COLOR]​
[/TD]
[TD]Data07[/TD]
[TD]
4​
[/TD]
[TD]
4​
[/TD]
[TD]
7​
[/TD]
[TD]
7​
[/TD]
[TD]
5​
[/TD]
[TD]
0​
[/TD]
[TD]
7​
[/TD]
[TD]
0​
[/TD]
[TD]
9​
[/TD]
[TD]
3​
[/TD]
[TD]
9​
[/TD]
[TD]
5​
[/TD]
[TD]
3​
[/TD]
[TD]
9​
[/TD]
[TD]
4​
[/TD]
[TD]
3​
[/TD]
[TD]
1​
[/TD]
[TD][/TD]
[TD]
7​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]12[/COLOR]​
[/TD]
[TD]Data08[/TD]
[TD]
9​
[/TD]
[TD]
0​
[/TD]
[TD]
6​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
6​
[/TD]
[TD]
7​
[/TD]
[TD]
8​
[/TD]
[TD]
2​
[/TD]
[TD]
9​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD]
5​
[/TD]
[TD]
8​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
5​
[/TD]
[TD]New Instrument[/TD]
[TD]
1​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]13[/COLOR]​
[/TD]
[TD]Data09[/TD]
[TD]
5​
[/TD]
[TD]
5​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD]
5​
[/TD]
[TD]
9​
[/TD]
[TD]
0​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD]
4​
[/TD]
[TD]
7​
[/TD]
[TD]
1​
[/TD]
[TD]
9​
[/TD]
[TD]
0​
[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD][/TD]
[TD]
5​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]14[/COLOR]​
[/TD]
[TD]Data10[/TD]
[TD]
9​
[/TD]
[TD]
4​
[/TD]
[TD]
7​
[/TD]
[TD]
2​
[/TD]
[TD]
9​
[/TD]
[TD]
1​
[/TD]
[TD]
4​
[/TD]
[TD]
8​
[/TD]
[TD]
7​
[/TD]
[TD]
4​
[/TD]
[TD]
2​
[/TD]
[TD]
9​
[/TD]
[TD]
0​
[/TD]
[TD]
9​
[/TD]
[TD]
8​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD][/TD]
[TD]
9​
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid"]
<tbody>[TR]
[TD]Sheet: AGV[/TD]
[/TR]
</tbody>[/TABLE]

Sheet "new instrument"

Excel 2016 (Windows) 32 bit
[TABLE="class: head"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[TH][/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]A[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]B[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]C[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]D[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]E[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]F[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]G[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]H[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]I[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]J[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]K[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]L[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]M[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]N[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]O[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]P[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Q[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]R[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]S[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]T[/COLOR]​
[/TH]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]1[/COLOR]​
[/TD]
[TD]H01[/TD]
[TD]H02[/TD]
[TD]H03[/TD]
[TD]H04[/TD]
[TD]H05[/TD]
[TD]H06[/TD]
[TD]H07[/TD]
[TD]H08[/TD]
[TD]H09[/TD]
[TD]H10[/TD]
[TD]H11[/TD]
[TD]H12[/TD]
[TD]H13[/TD]
[TD]H14[/TD]
[TD]H15[/TD]
[TD]H16[/TD]
[TD]H17[/TD]
[TD]H18[/TD]
[TD]H19[/TD]
[TD]H20[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]2[/COLOR]​
[/TD]
[TD]Data02[/TD]
[TD]
3​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
7​
[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
6​
[/TD]
[TD]
5​
[/TD]
[TD]
9​
[/TD]
[TD]
3​
[/TD]
[TD]
8​
[/TD]
[TD]
2​
[/TD]
[TD]
4​
[/TD]
[TD]
5​
[/TD]
[TD]
5​
[/TD]
[TD]
4​
[/TD]
[TD]
5​
[/TD]
[TD]New Instrument[/TD]
[TD]
6​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]3[/COLOR]​
[/TD]
[TD]Data03[/TD]
[TD]
0​
[/TD]
[TD]
2​
[/TD]
[TD]
7​
[/TD]
[TD]
7​
[/TD]
[TD]
5​
[/TD]
[TD]
5​
[/TD]
[TD]
5​
[/TD]
[TD]
4​
[/TD]
[TD]
6​
[/TD]
[TD]
4​
[/TD]
[TD]
7​
[/TD]
[TD]
7​
[/TD]
[TD]
1​
[/TD]
[TD]
5​
[/TD]
[TD]
4​
[/TD]
[TD]
9​
[/TD]
[TD]
5​
[/TD]
[TD]New Instrument[/TD]
[TD]
5​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]4[/COLOR]​
[/TD]
[TD]Data05[/TD]
[TD]
8​
[/TD]
[TD]
0​
[/TD]
[TD]
4​
[/TD]
[TD]
0​
[/TD]
[TD]
0​
[/TD]
[TD]
5​
[/TD]
[TD]
2​
[/TD]
[TD]
1​
[/TD]
[TD]
6​
[/TD]
[TD]
8​
[/TD]
[TD]
6​
[/TD]
[TD]
9​
[/TD]
[TD]
9​
[/TD]
[TD]
8​
[/TD]
[TD]
0​
[/TD]
[TD]
4​
[/TD]
[TD]
5​
[/TD]
[TD]New Instrument[/TD]
[TD]
1​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]5[/COLOR]​
[/TD]
[TD]Data06[/TD]
[TD]
6​
[/TD]
[TD]
0​
[/TD]
[TD]
2​
[/TD]
[TD]
3​
[/TD]
[TD]
6​
[/TD]
[TD]
8​
[/TD]
[TD]
2​
[/TD]
[TD]
3​
[/TD]
[TD]
9​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
5​
[/TD]
[TD]
9​
[/TD]
[TD]
8​
[/TD]
[TD]
9​
[/TD]
[TD]
3​
[/TD]
[TD]
6​
[/TD]
[TD]New Instrument[/TD]
[TD]
1​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]6[/COLOR]​
[/TD]
[TD]Data08[/TD]
[TD]
9​
[/TD]
[TD]
0​
[/TD]
[TD]
6​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
6​
[/TD]
[TD]
7​
[/TD]
[TD]
8​
[/TD]
[TD]
2​
[/TD]
[TD]
9​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD]
5​
[/TD]
[TD]
8​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
5​
[/TD]
[TD]New Instrument[/TD]
[TD]
1​
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid"]
<tbody>[TR]
[TD]Sheet: new instrument[/TD]
[/TR]
</tbody>[/TABLE]





Below is the amended macr
Click to expand...

Thank you so much it works!!
 
Upvote 0
You must log in or register to reply here.

Similar threads

U
  • Question Question
Excel VBA, Loop, Copy, Loop, Paste, Autofilter, return value, Loop.
Replies
0
Views
139
user29383902
U
A
  • Solved
Copy Entire Workbook, save as sheet name with current date, hide all sheets except one, & attach to email
Replies
2
Views
640
Amo840812
A
ChrisMac1
  • Question Question
VBA - Compare specific data in one column on one sheet, with the same column on 4 other sheets, copy specific cells if match found.
Replies
1
Views
438
ChrisMac1
ChrisMac1
C
  • Solved
Copy data from multiple sheets into a master sheet - VBA button stuck
Replies
3
Views
372
NdNoviceHlp
NdNoviceHlp
T
  • Solved
Find #REF! errors in multiple tables and delete those rows
Replies
7
Views
310
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

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