I have a spreadsheet with all my drivers and their years of safe driving.
How do I update each year when I want to add "1" to each cell in the column
for their years of safe driving.

Sounds like an excel question?

But anyway...
Type 1 into a blank cell
Copy it
Select all of the column > Paste special and choose "Add"

Use a copy just in case!

John
--
john ATSIGN PPTAlchemy.co.uk
Custom vba coding and PPT Makeovers
Free PPT Hints, Tips and Tutorials
http://www.pptalchemy.co.uk/powerpoi...tutorials.html




"diana" wrote:

> I have a spreadsheet with all my drivers and their years of safe driving.
> How do I update each year when I want to add "1" to each cell in the column
> for their years of safe driving.

Check your question

"diana" wrote:

> I have a spreadsheet with all my drivers and their years of safe driving.
> How do I update each year when I want to add "1" to each cell in the column
> for their years of safe driving.

Hi Diana,

The answer is gray, unfortunately. It is wonderful that you track your
drivers like this, I' sure it helps keep the roads save and the business
prosperous.

It depends on where the information is stored, either in a PowerPoint sheet
(more of a text grid, really) or an Excel spreadsheet. It also depends on
what version of PowerPoint you are using. PowerPoint 2003 and earlier are
easier to get into a sheet than 2007 using macros.

Post back with a few more details and we'll see what we can do for you.

Bill Dilworth



"diana" <(E-Mail Removed)> wrote in message
news:CD335257-4020-4BC7-8AA6-(E-Mail Removed)...
>I have a spreadsheet with all my drivers and their years of safe driving.
> How do I update each year when I want to add "1" to each cell in the
> column
> for their years of safe driving.

SPAM


@discussions.microsoft.com> wrote in message
news:E9FB681B-2955-48D1-A2D6-(E-Mail Removed)...
> Check your question
>
> "diana" wrote:
>
>> I have a spreadsheet with all my drivers and their years of safe driving.
>> How do I update each year when I want to add "1" to each cell in the
>> column
>> for their years of safe driving.