Programmatically transfer data from one excel file to another excel file

nikadon

New Member
Joined
Dec 24, 2012
Messages
26
Good day,

I have a few excel files one is a compilation of all the data submitted on the individual activity sheet that is completed daily. I want to programmatically extract the data from all the activity sheets to the dashboard monthly. Please see attached two files with examples of what is stored. Any help will be appreciated as there are numerous locations with many activity sheets to capture the data from.
Any help is welcomed.
Regards,
Cell Formulas
RangeFormula
B4B4=B179
C4:F4C4=B4+1
G4G4=F4
J4,J6:K23J4=G4
B6B6='\\fhccutil\ServiceImprovement\EurekaLawrenceTavern\2021\Ava-GayTucker\[Teller_MSRActivitySheet2021.xlsm]04.01.21'!$F$15
C6C6='\\fhccutil\ServiceImprovement\EurekaLawrenceTavern\2021\Ava-GayTucker\[Teller_MSRActivitySheet2021.xlsm]05.01.21'!$F$15
D6D6='\\fhccutil\ServiceImprovement\EurekaLawrenceTavern\2021\Ava-GayTucker\[Teller_MSRActivitySheet2021.xlsm]06.01.21'!$F$15
E6E6='\\fhccutil\ServiceImprovement\EurekaLawrenceTavern\2021\Ava-GayTucker\[Teller_MSRActivitySheet2021.xlsm]07.01.21'!$F$15
F6F6='\\fhccutil\ServiceImprovement\EurekaLawrenceTavern\2021\Ava-GayTucker\[Teller_MSRActivitySheet2021.xlsm]08.01.21'!$F$15
B7B7='\\fhccutil\ServiceImprovement\EurekaLawrenceTavern\2021\Camille Blair\[Teller_MSRActivitySheet2021.xlsm]04.01.21'!$F$15
C7C7='\\fhccutil\ServiceImprovement\EurekaLawrenceTavern\2021\Camille Blair\[Teller_MSRActivitySheet2021.xlsm]05.01.21'!$F$15
D7D7='\\fhccutil\ServiceImprovement\EurekaLawrenceTavern\2021\Camille Blair\[Teller_MSRActivitySheet2021.xlsm]06.01.21'!$F$15
E7E7='\\fhccutil\ServiceImprovement\EurekaLawrenceTavern\2021\Camille Blair\[Teller_MSRActivitySheet2021.xlsm]07.01.21'!$F$15
F7F7='\\fhccutil\ServiceImprovement\EurekaLawrenceTavern\2021\Camille Blair\[Teller_MSRActivitySheet2021.xlsm]08.01.21'!$F$15
G6:G23G6=SUM(B6:F6)
H6:H23H6='Target Sheet'!$K27
I6:I23,L6:L23I6=H6-G6
A6:A23A6='Target Sheet'!C27
B24:L24B24=SUM(B6:B23)


Teller_MSRActivitySheet2021.xlsm
ABCDEFGHIJKLMNOPQ
1TELLER/MEMBER SERVICE REPRESENTATIVE
2DailyYTD
3Total Transactions Processed0
4Total Member Service Interactions (General)8140
5DATE:Total Member Service Interactions (Loans - CIAF & My Cash)00
6NAME:Total Posting Discrepancies - Reversals00
7Total No. of Closed Referrals7151
8Total New Leads05
9Coaching SessionN
10
11
12CLOSED REFERRALS
13Daily Count of Persons that make up $value YTD Total Count of Persons that make up $value DailyWeeklyYTDAnnual
14ActualTargetActualTargetActualTarget
15DEPOSITS07$0.00$25,000.00$1,760,000.00$125,000.00$1,884,000.00$6,000,000.00
16LOANS214$425,000.00$100,000.00$5,787,193.72$500,000.00$6,952,255.07$24,000,000.00
17DEBIT CARD339318539120
18MEMBERSHIP02701452796
19ITRANSACT025013525120
20FIP113113513120
21LEADS1261291026480
29.01.21
Cell Formulas
RangeFormula
E15:E21,P3:P8P3=O3+'28.01.21'!P3
O4O4=SUBTOTAL(3,D25:D48)
O5O5=SUBTOTAL(3,D53:D76)
O6O6=SUBTOTAL(3,D81:D95)
O7O7=SUBTOTAL(9,D15:D21)
O8O8=SUBTOTAL(3,D121:D135)
H15:H21,P15:P21H15='04.01.21'!H15
J15:J21,L15:L21J15=F15+'28.01.21'!J15
N15:N21N15=F15+'28.01.21'!N15
Cells with Data Validation
CellAllowCriteria
D5Datebetween 1/11/2019 and NOW()
O9:O10ListY,N
I8ListY,N
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Watch MrExcel Video

Forum statistics

Threads
1,132,704
Messages
5,654,829
Members
418,155
Latest member
demasisi

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
Top