Updating information from one changing spreadsheet to another

**stryped** · 07-29-2021, 10:17 AM

Hello,

I have a manpower budget that lists the number of employees allowed in each area and shift. I have set up a payroll report that I run in ADP that shows the actual people in each area/shift.

I would like to be able to run this report periodically and paste it in a workbook that will take the "actual" number of employees per area and shift and insert it in another tab that will compare those "actual" numbers to "Budget" numbers.

I have included a sample for reference.

Any help is greatly appreciated!

**AliGW** · 07-29-2021, 10:23 AM

Before we start, you have clearly updated from Excel 2003. What are yo now using? Please update your profile.

**AliGW** · 07-29-2021, 10:27 AM

How about this?

Excel 2016 (Windows) 32 bit

	A	B	C	D	E
1	Area	shift	Budget	Actual	Difference
2	Loading	1	10	4	-6
3	Loading	2	5	6	1
4	Loading	3	4	4	0
5
6	X-ray	1	7	5	-2
7	X-ray	2	6	5	-1
8	X-ray	3	5	2	-3

Sheet: Manpower Budget

Excel 2016 (Windows) 32 bit

	D	E
2	=IF(A2="","",COUNTIFS('ADP Manpower Report'!$A$2:$A$27,'Manpower Budget'!A2,'ADP Manpower Report'!$B$2:$B$27,'Manpower Budget'!B2))	=IF(D2="","",D2-C2)

Sheet: Manpower Budget

**stryped** · 07-29-2021, 12:03 PM

Dumb question, where can I go to look up what my current version is?

**stryped** · 07-29-2021, 01:05 PM

Can you explain to me how this works? Also, the report I will be inserting from time to time from ADP may have the numbers in different locations each time due to the hiring and terminating of people if that makes sense. Will that matter?

**JeteMc** · 07-31-2021, 12:37 PM

As to finding the version, the following may help: https://support.microsoft.com/en-us/...9-e334518b8b19

**AliGW** · 07-31-2021, 12:39 PM

Originally Posted by stryped

Dumb question, where can I go to look up what my current version is?

Two ways:

1. Launch the app and read what it says on the splash screen.
2. Go to File | Account and see what it tells you there.

**AliGW** · 07-31-2021, 12:41 PM

To the formula:

=IF(A2="","",COUNTIFS('ADP Manpower Report'!$A$2:$A$27,'Manpower Budget'!A2,'ADP Manpower Report'!$B$2:$B$27,'Manpower Budget'!B2))

If cell A2 is blank, return a blank.

If not, count the rows where column A = A2 AND column B = B2.

https://support.microsoft.com/en-us/...c-aa8c2a866842

Updating information from one changing spreadsheet to another

LinkBack

Thread Tools

Rate This Thread

Display

Updating information from one changing spreadsheet to another

Re: Updating information from one changing spreadsheet to another

Re: Updating information from one changing spreadsheet to another

Re: Updating information from one changing spreadsheet to another

Re: Updating information from one changing spreadsheet to another

Re: Updating information from one changing spreadsheet to another

Re: Updating information from one changing spreadsheet to another

Re: Updating information from one changing spreadsheet to another

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Inconsistent updating of spreadsheet formula when changing file name

Updating cells with information and changing dates on two sheets.

[SOLVED] Auto Updating Spreadsheet with Information in a different order

Updating another spreadsheet based on certain information and certain conditions

Updating Data in Spreadsheet by utilizing a separate Spreadsheet

Updating information and automatically changing a cell's appearance

[SOLVED] updating a spreadsheet in 1 field w/ out changing values in anoth

Bookmarks

Bookmarks

Posting Permissions