excel wssi

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel WSSI

Excel WSSI

resolvedResolved · Urgent Priority · Version 2003

Shaun has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course
Excel VBA Intro Intermediate course

Excel WSSI

I have an excel wssi that looks at sales, stock and intake by week.

I also have an Open To Buy variable that calculates the difference between my target stock and my current stock by week.

I then have a variabel called "Trigger Dates" that allows me to enter an "x" on weeks where i want intake.

What i need is for where an "x" is inserted, the OTB values are summed until the next week with an "x".

Therefore if i have OTB vales as follows;

wk 1 = 100
wk 2 = 100
wk 3 = 100
wk 4 = 100
wk 5 = 100

and i place a trigger date "x" under weeks 1 and 3 then my OTB values should be 200 for wk 1 and 300 for wk 3.

I have tried to use a sumif calculation but i do not know how to make it only sum between "x" and "x".

The "x" triger dates need to be able to be changed and so the OTB calculation to change accordingly.

Hope this makes sense?!

Can anyone help?

RE: Excel WSSI

Hi Saun

Thank you for your question.

I think the solution to your problem is probably simple enough; however it is difficult to advise without seeing the workbook in question

Could you email a copy to me at stephenATstl-training.co.uk and I will resolve the rpoblem for you.

Regards

Stephen


 

Excel tip:

How to select certain data in an Excel 2010 workbook

If you want to select the correct data set in a page full of data, the most accurate and efficient way of doing this is to use the ''Shift and Click'' technique.

For example: If you want to select all data in cells A2 to E10, then click on cell A2, hold down the Shift key and click on cell E10 and all the data you want to see is highlighted.

Keep holding down the Shift key and you can move from cell E10 to any other cell in the spreadsheet.

View all Excel hints and tips


Server loaded in 0.09 secs.