Community

1

I have developed a dashboard sheet that contains data from 3 different  source sheets.  Unfortunately, it requires me to manually input the data.  Is there a way to use a formluain  one sheet that relies on data from another sheet.  I know this can be done in excel, but can't seem to find a solution

5

I asked about this back in April and got a few suggestions but nothing that really worked for me so I'll try again.

 

I keep track of the hours charged to around 35 projects by people in a dozen functional areas on a weekly basis and send the monthly total into our finance team for their revenue