Auto copy/paste?

Hi all

Ok, so i have created a stock check system on excell which is working great. However i am becoming tired of copy and pasting between worksheets. Is there any of setting up some kind of function so this is don automatically?

for example; My current functions calculate the total amount of stock before stock check (opening count+deliveries) then gives total usage after i enter the closing count figures (total stock-closing count) I would like the closing count to automatically populate into the next weeks opening count, which is on the next worksheet.

the total usage is also copy and pasted into another worksheet which calculates total usage cost. I would like the usage column to automatically populate onto this usage costs worksheet.

Any tips?

Thanks

Ads

put formulae on the "next" worksheet that point back to the cells on the previous worksheet.

Originally Posted by Mallycat

put formulae on the "next" worksheet that point back to the cells on the previous worksheet.

Im sorry, could you please explain this?