Forum home » Delegate support and help forum » Microsoft Excel Training and help » Delivery Schedule

Delivery Schedule

ResolvedVersion 2010

Wed 26 Nov 2014, 17:12 Delegate Matthew said...

Matthew has attended:
Excel VBA Intro Intermediate course

Delivery Schedule

I am trying to create a delivery schedule for a colleague which has multiple sheets for each individual supplier. Is there a way of collating the information on to a calendar to allow them to know what deliveries they will be receiving on a weekly basis?

Mon 1 Dec 2014, 12:24 Trainer Marius said...

RE: Delivery Schedule

Hello Matthew,

Thank you for your question. Do you use (or need to use) a specific calendar (e.g. Outlook or Google calendar) or an Excel calendar template?

Kind regards
Marius Barnard
Excel Trainer

Mon 1 Dec 2014, 14:14 Delegate Matthew said...

RE: Delivery Schedule

Marius,

The colleague that asked me to looking to this wanted it on an excel calendar but since Wednesday I have learnt that I can link excel to outlook so I have sent the instructions on how to do that. Thank you for responding.

Thanks

Matt

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips

Delivery Schedule

Delivery Schedule

RE: Delivery Schedule

RE: Delivery Schedule

Excel articles

Excel tip:

Sum Up All the Values in A Column