With-in one workbook I am trying to link several spreadsheets’ entries into one colum

[Chuckg]

I have one spreadsheet titled "Collections" and another titled "Customer
Service." The last spreadsheet is titled "Resources." Each
spreadsheet has every day of the year listed in column A1 down. My
goal is that if any entry (like the name Chuck) is made into any
cell(s) - other than the dated cells - on Training 1 &/or 2 that entry
is populated into a specific column on the Resource spreadsheet.

In other words:

I want the entry “Chuck” in E10 on the Collection spreadsheet to
populate in B10 on the Resource spreadsheet.
I want the entry “Chuck” in C22 on the Customer Service spreadsheet to
populate in B22 on the Resource spreadsheet.
ETC.
ETC.

If the entry “Chuck” is populated more than once in any dated row on
any spreadsheet I need an error to populate in the matching cell in the
designated column on the Resource spreadsheet.

I think that I’m almost there with this formula:
=IF('CUSTOMER SERVICE'!A:H="CHUCK","CHUCK", "")
However, this argument doesn’t put the entry in the specific designated
column on the Resource spreadsheet.

Make sense?

 

[Jonathan Rynd]

I have one spreadsheet titled "Collections" and another titled
"Customer
Service." The last spreadsheet is titled "Resources." Each
spreadsheet has every day of the year listed in column A1 down. My
goal is that if any entry (like the name Chuck) is made into any
cell(s) - other than the dated cells - on Training 1 &/or 2 that entry
is populated into a specific column on the Resource spreadsheet.

I'll assume that all entries in Collections and Customer Service are in
columns B through E. If that's not the case, it's probably better to use
Visual Basic.

I want the entry “Chuck” in E10 on the Collection spreadsheet to
populate in B10 on the Resource spreadsheet.
I want the entry “Chuck” in C22 on the Customer Service spreadsheet to
populate in B22 on the Resource spreadsheet.

If the entry “Chuck” is populated more than once in any dated row on
any spreadsheet I need an error to populate in the matching cell in the
designated column on the Resource spreadsheet.

put in cell B1 of resource spreadsheet
=if((not(length(Collections!B1))+not(length(Collections!C1))+not(length
(Collections!D1)+not(length(Collections!E1))+not(length([Customer
Service]!B1))+not(length([Customer Service]!C1))+not(length([Customer
Service]!D1)+not(length([Customer Service]!E1)))>1,"Error",(Collections!
B1)&(Collections!C1)&(Collections!D1)&(Collections!E1)&[Customer
Service]!B1)&[Customer Service]!C1)&([Customer Service]!D1)&([Customer
Service]!E1))

and fill down

 

[Jonathan Rynd]

put in cell B1 of resource spreadsheet
=if((not(length(Collections!B1))+not(length(Collections!C1))+not(length
(Collections!D1)+not(length(Collections!E1))+not(length([Customer
Service]!B1))+not(length([Customer Service]!C1))+not(length([Customer
Service]!D1)+not(length([Customer Service]!E1)))>1,"Error", (Collections!
B1)&(Collections!C1)&(Collections!D1)&(Collections!E1)&[Customer
Service]!B1)&[Customer Service]!C1)&([Customer Service]!D1)&([Customer
Service]!E1))

Oops, my bad -- I should have used apostrophes instead of square
brackets. Try

put in cell B1 of resource worksheet
=if((not(length(Collections!B1))+not(length(Collections!C1))+not(length
(Collections!D1)+not(length(Collections!E1))+not(length('Customer
Service'!B1))+not(length('Customer Service'!C1))+not(length('Customer
Service'!D1)+not(length('Customer Service'!E1)))>1,"Error",(Collections!
B1)&(Collections!C1)&(Collections!D1)&(Collections!E1)&'Customer
Service'!B1)&'Customer Service'!C1)&('Customer Service'!D1)&('Customer
Service'!E1))