View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SANDRA SANDRA is offline
external usenet poster
 
Posts: 1
Default HOW DO I COPY A TOTAL FIGURE FROM 1 SHEET TO NEXT ADDING RUNNING T

I HAVE MADE A WORKBOOK FOR A MONTHS WORTH OF SALES AN D OTHER STOCK ENTRIES.
1 HAVE TODAY, YESTERDAY AND TOTAL IN EACH SHEET.
I WANT TO COPY TOTAL FIGURE INTO YESTERDAY ON EVERY SHEET.
IS THER A WAY OF DOING THIS WITHOUT PHYSICALLY TYPING IN THE REFERENCE TO
PREVIOUS SHEET.
EX. SHEET 2 REFERS TO SHEET 1. SHEET 3 REFERS TO SHEET 2.

CAN ANYONE PLEASE HELP ME
THANKS
--
SANDRA