Quote:
Originally Posted by NBVC
My sample is assuming you are adding new rows in the results sheet (even for same Item). It does not assume you are overwriting previous information.
|
Sorry no, I just want the result sheet to show the latest set of figures and as each week passes, I want to input that weeks data against Item A and for it to show on a new Row in the item sheet.
If this cannot be done, is it better to input the new data in it's own sheet and have the result sheet pull that data into the correct cells.
At the moment, if I want to send out the sales information, I have to look into each items sheet to find the latest numbers then copy and paste each one into another table.
Rob