Question - Data extrat from one workbook into another

[John_Jay]

Good Day excel Guru's!

I am a novice with excel but highly addicted!

My issue is this:

I run a small business and I would like to track my payroll from several departments into an easy to analyze workbook. The trick is that ADP generates a weekly report in Excel format (which ill try to attach). The cells I would like to pull in (Hours total and Dollars for each department) dont always list in the same cells each week (as rows are added based on employee roster changes the cell addresses move down)

My question is:

1. What is the best way for me to macro in the details I am looking for? Id like to open a pre-designed workbook, choose the report to extract the data from and simply import said data. I would also like to house the reports in shared dropbox if possible as well.

Looking for the best way that is basically fool proof and just works.

Many Thanks!

Department Detail Report
Date Range: 04/14/2019 - 04/20/2019 and Employee Effective As Of : 04/23/2019
Worked Department: 000100
Department					Last Name	First Name			Position ID
Worked Department			Pay Code									Hours			Dollars
000100					Employee	1				QCD000067
000100					REGULAR-Regular									28.72			$287.17
										Subtotal				28.72			$287.17
000100					Employee	1				QCD000077
000100					REGULAR-Regular									37.37			$411.03
										Subtotal				37.37			$411.03
000100					Employee	1				QCD000062
000100					REGULAR-Regular									12.52			$125.17
										Subtotal				12.52			$125.17
										Total for: 000100				78.61			$823.37
ADP																	Powered by Automatic Data Processing, Inc.
Prepared On: 04/23/2019 06:10:48 PM												Page 1 of 8
Department Detail Report
Date Range: 04/14/2019 - 04/20/2019 and Employee Effective As Of : 04/23/2019
Worked Department: 000150
Department					Last Name	First Name			Position ID
Worked Department			Pay Code									Hours			Dollars
000150					Employee	1				QCD000092
000150					REGULAR-Regular									20.67			$248.00
										Subtotal				20.67			$248.00
000150					Employee	1				QCD000091
000150					REGULAR-Regular									17.23			$172.33
										Subtotal				17.23			$172.33
										Total for: 000150				37.90			$420.33
ADP																	Powered by Automatic Data Processing, Inc.
Prepared On: 04/23/2019 06:10:48 PM												Page 2 of 8
Department Detail Report
Date Range: 04/14/2019 - 04/20/2019 and Employee Effective As Of : 04/23/2019
Worked Department: 000200
Department					Last Name	First Name			Position ID
Worked Department			Pay Code									Hours			Dollars
000200					Employee	1				QCD000063
000200					REGULAR-Regular									4.95			$49.50
										Subtotal				4.95			$49.50
000200					Employee	1				QCD000069
000200					REGULAR-Regular									21.03			$210.33
										Subtotal				21.03			$210.33
										Total for: 000200				25.98			$259.83
ADP																	Powered by Automatic Data Processing, Inc.
Prepared On: 04/23/2019 06:10:48 PM												Page 3 of 8
Department Detail Report
Date Range: 04/14/2019 - 04/20/2019 and Employee Effective As Of : 04/23/2019
Worked Department: 000300
Department					Last Name	First Name			Position ID
Worked Department			Pay Code									Hours			Dollars
000300					Employee	1				QCD000089
000300					REGULAR-Regular									35.62			$356.17
										Subtotal				35.62			$356.17
000300					Employee	1				QCD000051
000300					REGULAR-Regular									37.00			$370.00
										Subtotal				37.00			$370.00
000300					Employee	1				QCD000060
000300					OVERTIME-Overtime									0.03			$0.50
000300					REGULAR-Regular									40.02			$400.17
										Subtotal				40.05			$400.67
000300					Employee	1				QCD000056
000300					OVERTIME-Overtime									0.13			$2.00
000300					REGULAR-Regular									39.95			$399.50
										Subtotal				40.08			$401.50
000300					Employee	1				QCD000057
000300					OVERTIME-Overtime									0.08			$1.25
000300					REGULAR-Regular									40.05			$400.50
										Subtotal				40.13			$401.75
000300					Employee	1				QCD000061
000300					OVERTIME-Overtime									0.05			$0.75
000300					REGULAR-Regular									39.95			$399.50
										Subtotal				40.00			$400.25
										Total for: 000300				232.88			$2,330.34
ADP																	Powered by Automatic Data Processing, Inc.
Prepared On: 04/23/2019 06:10:48 PM												Page 4 of 8
Department Detail Report
Date Range: 04/14/2019 - 04/20/2019 and Employee Effective As Of : 04/23/2019
Worked Department: 000400
Department					Last Name	First Name			Position ID
Worked Department			Pay Code									Hours			Dollars
000400					Employee	1				QCD000082
000400					REGULAR-Regular									27.47			$274.67
										Subtotal				27.47			$274.67
										Total for: 000400				27.47			$274.67
ADP																	Powered by Automatic Data Processing, Inc.
Prepared On: 04/23/2019 06:10:48 PM												Page 5 of 8
Department Detail Report
Date Range: 04/14/2019 - 04/20/2019 and Employee Effective As Of : 04/23/2019
Worked Department: 000500
Department					Last Name	First Name			Position ID
Worked Department			Pay Code									Hours			Dollars
000500					Employee	1				QCD000070
000500					REGULAR-Regular									32.33			$323.33
										Subtotal				32.33			$323.33
										Total for: 000500				32.33			$323.33
ADP																	Powered by Automatic Data Processing, Inc.
Prepared On: 04/23/2019 06:10:48 PM												Page 6 of 8
Department Detail Report
Date Range: 04/14/2019 - 04/20/2019 and Employee Effective As Of : 04/23/2019
Worked Department: 000600
Department					Last Name	First Name			Position ID
Worked Department			Pay Code									Hours			Dollars
000600					Employee	1				QCD000081
000600					REGULAR-Regular									37.30			$634.10
										Subtotal				37.30			$634.10
										Total for: 000600				37.30			$634.10
ADP																	Powered by Automatic Data Processing, Inc.
Prepared On: 04/23/2019 06:10:48 PM												Page 7 of 8
Department Detail Report
Date Range: 04/14/2019 - 04/20/2019 and Employee Effective As Of : 04/23/2019
Pay Code Summary
														Hours			Dollars
	REGULAR-Regular									78.61			$823.37
	Total for Worked Department: 000100							78.61			$823.37
	REGULAR-Regular									37.90			$420.33
	Total for Worked Department: 000150							37.90			$420.33
	REGULAR-Regular									25.98			$259.83
	Total for Worked Department: 000200							25.98			$259.83
	OVERTIME-Overtime									0.29			$4.50
	REGULAR-Regular									232.59			$2,325.84
	Total for Worked Department: 000300							232.88			$2,330.34
	REGULAR-Regular									27.47			$274.67
	Total for Worked Department: 000400							27.47			$274.67
	REGULAR-Regular									32.33			$323.33
	Total for Worked Department: 000500							32.33			$323.33
	REGULAR-Regular									37.30			$634.10
	Total for Worked Department: 000600							37.30			$634.10
											Grand Total			472.47			$5,065.97
ADP																	Powered by Automatic Data Processing, Inc.
Prepared On: 04/23/2019 06:10:48 PM												Page 8 of 8

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