One book, 5 sheets and 1 sheet for totals

  • Thread starter Thread starter Tanja
  • Start date Start date
T

Tanja

Hello

My problem is as follows:

I have created 5 sheets (one for each working day). Every
day is new information entered into these sheets.
Sometimes more and sometimes nothing at all. On Friday we
have to send the whole information of the week (bringing
the information of every day) on one report. The report
has to read every information put in every day.

How can I do that automatically so that I don't have to
copy everything into that one form. The best solution
would put the information into the other form
automatically.

I'm really stuck on this. I know how to get the
information over the other form via formula but then I
have many zeros if in the first form is nothing. Or some
information would get lost by overwriting.

Thanks for your help in advance!

Tanja
 
Back
Top