formula

P

Phxlatinoboi®

I created a spreadsheet that will automatically add everyone's hours for the
week. My next step is to be able to automatically insert the hours as it is
sent from the managers of each store. What would be the easiest way to do
this?
 
T

Toppers

How is the data sent (format etc)? And what is/are the format(s) in your
receiving spreadsheet?
 
P

Phxlatinoboi®

the format will be sent and received as follows

A2 B2 C2 D2
Agent A 10 7 Total of B2 & C2
Agent B 11 8 Total of B3 & C3
Agent C 10 7 Total of B4 & C4
 
Top