Creating a spread sheet for VAT.

Occasional Visitor

Hi .

I am completely new to excel. I am trying to create a spread sheet to input my sales figures, purchases etc. I appear to have done this ok on sheet 1, however I have opened sheet 2 in the same screen which I need to use to analyse the data from sheet 1. for example :

sheet 2 box 1 should be the vat on my sales and other outputs comes from  a total cell, box 2 is zero(import purchases) box 3 is total of box 1 &2 should be the same figure, box 4 is vat reclaimed on purchases so I need to analyse the total of all these, box 4 is difference between box 3 &4, box 6 is total sales box 7 is total purchases.

can any help or tell me if this is possible I need it for MDT purposes.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies