Hello Everyone,
I am designing an Excel sheet at my work.
I have a sheet of 5 cells table which is my daily testing sheet, in which I type the 5 results everyday.
then there is another excel sheet which is the monthly sheet that has all the records of the month ( which contains 100 cells table, the total number of the whole daily tests)
So everyday I copy 5 results and then the following 5 results..etc to the monthly sheet.
In order to save time of copy/past results from the two sheet, I made a reference cell in order to type once only in the daily testing ( 5 records sheet), but the results will show only on the 1st 5 cells in the 100 cells monthly sheet.
I want to be able to write the first 5, then when I come for testing the following day it should copy the new results in the following 5 not in the same 5 I refered to.
will I be able to make a register sheet that refer to another excel sheet and results shows in sequence ?
Help me plz, Thanks in advance
Bookmarks