HOW DO I COPY A TOTAL FIGURE FROM 1 SHEET TO NEXT ADDING RUNNING T

S

SANDRA

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy entire row from another sheet onto first sheet if a unique text matches 1
I need ONLY subtotals copied to a second sheet 4
Copy Data from 1 Sheet to Another 3
Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to a list onsame & another sheet 27
How Do I DO IF with DATE 2
Copy Info from 1 sheet to another within same workbook 1
extact certain information from sheet 1 to shhet 2 columns e:e and 2
How do I reference a cell to another in the preceding worksheet 8

Top