C
cody44
Hi,
Please go easy on me as this is my first post and a little complicated
The scenario being that I have a business and need to do a Profit & Los
account on a week to week basis.
In one worksheet I have a budget sheet displaying sales and expense
from week one to week 52. This sheet has been completed with a manua
input. Each column has a name, ie
Period1 week 1
Period1 week 2
ECT ECT
period 1 has 4 weeks period 2 has 4 weeks period 5 has 5 weeks
period 6 has 4 weeks and so forth, 4-4-5 weeks, 4-4-5 weeks ect.
I want to set up a new sheet for inputting my sales and expenses on
week to week basis, however I need to print off a sheet displayin
three columns, being
ACTUAL SALES
The week only
PERIOD SALES
This will show sales in the period I am in (so if im in period 4 week
it will need to display the totals of all 5 weeks)
ACCUMILITIVE SALES
This will show week1 period one to the present week.
Remember I will need to print this off week to week and may need a
input button / Macro to update
Once I can set up the above I will put the BUDGET column next to th
above to show variance.
I hope the above is clear enough and hope you can help. Many thanks i
advance and will keep checking this out.
Mar
Please go easy on me as this is my first post and a little complicated
The scenario being that I have a business and need to do a Profit & Los
account on a week to week basis.
In one worksheet I have a budget sheet displaying sales and expense
from week one to week 52. This sheet has been completed with a manua
input. Each column has a name, ie
Period1 week 1
Period1 week 2
ECT ECT
period 1 has 4 weeks period 2 has 4 weeks period 5 has 5 weeks
period 6 has 4 weeks and so forth, 4-4-5 weeks, 4-4-5 weeks ect.
I want to set up a new sheet for inputting my sales and expenses on
week to week basis, however I need to print off a sheet displayin
three columns, being
ACTUAL SALES
The week only
PERIOD SALES
This will show sales in the period I am in (so if im in period 4 week
it will need to display the totals of all 5 weeks)
ACCUMILITIVE SALES
This will show week1 period one to the present week.
Remember I will need to print this off week to week and may need a
input button / Macro to update
Once I can set up the above I will put the BUDGET column next to th
above to show variance.
I hope the above is clear enough and hope you can help. Many thanks i
advance and will keep checking this out.
Mar