Extract selected data from closed workbook

A

aliaslamy2k

Active Member
Joined
Sep 15, 2009
Messages
416
Office Version
  1. 2019
Platform
  1. Windows
Dear Experts,

Can i get a formula or VBA code to extract selected cells from closed workbooks
I have around 120 workbooks in a folder with all stations names, which will be replaced every month with new workbook but the file name will remain same.
I need to get the data from particular cells and paste in my final excel sheet.


Below cells to be copied from all stations workbooks.
J4, J7, J8, J9, E20, G18, I18, E21, G21, I21, E22, F25, F26, F27, F30, F31, F32, D35, D36, H35, H36, F39, G39, H39, F40, H40, F43, H43, J45, J47, J49


Below is the current formula I am using, but when i replace the workbook, my final sheet is not capturing the latest information.
='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$J$7


To be pasted here

Sheet3


ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAH
1
FREQUENCIES



TOTAL PAX - IN

TOTAL PAX - OUT

DNBUG

DG

CGO
MAIL
MEALS ON

WASTAGE

EXCESS BAGG

MISHANDLED
2StationsA340/B777A330A300A319/A320/A321
FJYFJY
J to FY to JY to FF to JJ to YF to YInOutIn OutFJYFJYTargetAchievedWaivedNbrCompensation
3ALG000 49
07428283078110488
090020000078110488000000062250
4AMD0310 31
0231453301363639
030030186939735219014337300791967920015923451803
5AMM0280 31
3830431738304575
003000635035324665141541504574320-1000270
6ARN000 31
0297720903416437
0550000301989358435748303666505025680271353441600
7ATH0620 62
0481829505719396
02000052887579213220057794040680340450661916
8ATQ0310 31
015840570963967
059000085110307000102393706-30014216390401947
9AUH01690 170
847010678807013241
00000057701260587815136266881013159740-82050836.4455315810004
10BAH01390 173
122371462812231413298
004000459537410173659982769312171012986-6-4-31211090376243.391018152295
11BCN000 31
0411591806467528
03000003438413485190006637606017780176911976300

<colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 87px"></colgroup> <tbody>
</tbody>

Spreadsheet Formulas
CellFormula
B3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$J$4
C3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$J$7
D3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$J$8
E3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$J$9
G3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$E$20
H3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$G$18
I3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$I$18
J3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$E$21
K3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$G$21
L3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$I$21
N3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$F$25
O3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$F$26
P3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$F$27
Q3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$F$30
R3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$F$31
S3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$F$32
T3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$D$35
U3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$D$36
V3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$H$35
W3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$H$36
X3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$F$39
Y3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$G$39
Z3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$H$39
AA3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$F$40
AB3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$G$40
AC3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$H$40
AD3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$F$43
AE3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$H$43
AF3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$J$45
AG3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$J$47
AH3='D:\Extract Data\DATABASE\[ALG.xls]GS use'!$J$49
B4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$J$4
C4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$J$7
D4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$J$8
E4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$J$9
G4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$E$20
H4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$G$18
I4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$I$18
J4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$E$21
K4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$G$21
L4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$I$21
N4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$F$25
O4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$F$26
P4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$F$27
Q4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$F$30
R4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$F$31
S4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$F$32
T4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$D$35
U4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$D$36
V4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$H$35
W4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$H$36
X4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$F$39
Y4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$G$39
Z4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$H$39
AA4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$F$40
AB4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$G$40
AC4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$H$40
AD4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$F$43
AE4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$H$43
AF4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$J$45
AG4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$J$47
AH4='D:\Extract Data\DATABASE\[AMD.xls]For GS use'!$J$49
B5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$J$4
C5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$J$7
D5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$J$8
E5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$J$9
G5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$E$20
H5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$G$18
I5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$I$18
J5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$E$21
K5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$G$21
L5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$I$21
N5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$F$25
O5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$F$26
P5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$F$27
Q5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$F$30
R5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$F$31
S5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$F$32
T5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$D$35
U5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$D$36
V5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$H$35
W5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$H$36
X5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$F$39
Y5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$G$39
Z5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$H$39
AA5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$F$40
AB5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$G$40
AC5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$H$40
AD5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$F$43
AE5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$H$43
AF5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$J$45
AG5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$J$47
AH5='D:\Extract Data\DATABASE\[AMM.xls]For GS use'!$J$49
B6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$J$4
C6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$J$7
D6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$J$8
E6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$J$9
G6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$E$20
H6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$G$18
I6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$I$18
J6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$E$21
K6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$G$21
L6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$I$21
N6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$F$25
O6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$F$26
P6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$F$27
Q6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$F$30
R6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$F$31
S6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$F$32
T6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$D$35
U6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$D$36
V6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$H$35
W6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$H$36
X6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$F$39
Y6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$G$39
Z6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$H$39
AA6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$F$40
AB6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$G$40
AC6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$H$40
AD6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$F$43
AE6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$H$43
AF6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$J$45
AG6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$J$47
AH6='D:\Extract Data\DATABASE\[ARN.xls]For GS use'!$J$49
B7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$J$4
C7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$J$7
D7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$J$8
E7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$J$9
G7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$E$20
H7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$G$18
I7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$I$18
J7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$E$21
K7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$G$21
L7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$I$21
N7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$F$25
O7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$F$26
P7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$F$27
Q7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$F$30
R7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$F$31
S7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$F$32
T7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$D$35
U7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$D$36
V7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$H$35
W7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$H$36
X7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$F$39
Y7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$G$39
Z7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$H$39
AA7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$F$40
AB7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$G$40
AC7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$H$40
AD7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$F$43
AE7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$H$43
AF7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$J$45
AG7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$J$47
AH7='D:\Extract Data\DATABASE\[ATH.xls]For GS use'!$J$49
B8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$J$4
C8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$J$7
D8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$J$8
E8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$J$9
G8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$E$20
H8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$G$18
I8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$I$18
J8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$E$21
K8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$G$21
L8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$I$21
N8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$F$25
O8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$F$26
P8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$F$27
Q8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$F$30
R8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$F$31
S8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$F$32
T8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$D$35
U8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$D$36
V8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$H$35
W8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$H$36
X8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$F$39
Y8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$G$39
Z8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$H$39
AA8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$F$40
AB8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$G$40
AC8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$H$40
AD8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$F$43
AE8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$H$43
AF8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$J$45
AG8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$J$47
AH8='D:\Extract Data\DATABASE\[ATQ.xls]For GS use'!$J$49
B9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$J$4
C9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$J$7
D9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$J$8
E9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$J$9
G9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$E$20
H9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$G$18
I9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$I$18
J9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$E$21
K9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$G$21
L9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$I$21
N9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$F$25
O9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$F$26
P9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$F$27
Q9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$F$30
R9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$F$31
S9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$F$32
T9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$D$35
U9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$D$36
V9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$H$35
W9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$H$36
X9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$F$39
Y9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$G$39
Z9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$H$39
AA9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$F$40
AB9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$G$40
AC9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$H$40
AD9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$F$43
AE9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$H$43
AF9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$J$45
AG9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$J$47
AH9='D:\Extract Data\DATABASE\[AUH.xls]For GS use'!$J$49
B10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$J$4
C10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$J$7
D10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$J$8
E10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$J$9
G10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$E$20
H10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$G$18
I10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$I$18
J10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$E$21
K10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$G$21
L10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$I$21
N10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$F$25
O10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$F$26
P10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$F$27
Q10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$F$30
R10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$F$31
S10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$F$32
T10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$D$35
U10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$D$36
V10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$H$35
W10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$H$36
X10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$F$39
Y10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$G$39
Z10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$H$39
AA10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$F$40
AB10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$G$40
AC10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$H$40
AD10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$F$43
AE10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$H$43
AF10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$J$45
AG10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$J$47
AH10='D:\Extract Data\DATABASE\[BAH.xls]For GS use'!$J$49
B11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$J$4
C11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$J$7
D11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$J$8
E11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$J$9
G11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$E$20
H11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$G$18
I11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$I$18
J11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$E$21
K11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$G$21
L11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$I$21
N11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$F$25
O11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$F$26
P11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$F$27
Q11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$F$30
R11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$F$31
S11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$F$32
T11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$D$35
U11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$D$36
V11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$H$35
W11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$H$36
X11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$F$39
Y11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$G$39
Z11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$H$39
AA11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$F$40
AB11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$G$40
AC11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$H$40
AD11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$F$43
AE11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$H$43
AF11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$J$45
AG11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$J$47
AH11='D:\Extract Data\DATABASE\[BCN.xls]For GS use'!$J$49

<tbody>
</tbody>

<tbody>
</tbody>


Excel tables to the web >> Excel Jeanie HTML 4
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Sort by date Sort by votes
Dear Experts,

Any help on above would be highly appreciated.

Rgds,
AB
 
Upvote 0
These are links. You have to update them. Closing and reopening the workbook should pop up a dialogue box asking whether you want to update the links. You can update manually, but which version of Excel are you using?
 
Upvote 0
Hi Cal,

Exactly the same, i am getting the pop up message to update the link. But when i click " Update" its not updating at all.

I am using excel 2010.

Rgds,
AB
 
Upvote 0
You must log in or register to reply here.

Similar threads

k3yn0t3
  • Solved
Simple Macro to Dupe Sheet and Update Cell Value by +1 [feat. xl2bb mini-sheet]
Replies
8
Views
292
k3yn0t3
k3yn0t3
O
  • Question
Running through a Config and pulling out the relevant information using keywords into smaller sheets
Replies
0
Views
120
oitbc
O
A
  • Solved
Fill down formulas and Do Until "No more data"
Replies
4
Views
733
felixstraube
F
L
  • Question
VBA Email extract problem
Replies
0
Views
325
Liverlee
L
K
  • Question
conditional formatting question
Replies
2
Views
149
kerm007
K

Forum statistics

Threads
1,214,551
Messages
6,120,159
Members
448,948
Latest member
spamiki

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