.xls spread sheet

i absolutely cannot stand this program...anyhow...a client has sent an .xls spreadsheet to make a day timer, they have it all setup and such, i just need to create 365 of these to print one for everyday. is there some way in excel to automate the date? they currently have the jan 01, 2008 set in the header.

excel help doesn't give me any answers...? any ideas? i know how to do this in indy but it takes a little more work.
 
Re: .xls spread sheet

if you click on the cell with the date on - a box appears around the cell - and a + in the bottem right corner, click on the + and drag down and the date should replicatre itself and add one day
 
Re: .xls spread sheet

The date was actually contained in the header, not in a cell so that method wouldn't work. The job was completed outside of excel, thanks for your help though!
 

PressWise

A 30-day Fix for Managed Chaos

As any print professional knows, printing can be managed chaos. Software that solves multiple problems and provides measurable and monetizable value has a direct impact on the bottom-line.

“We reduced order entry costs by about 40%.” Significant savings in a shop that turns about 500 jobs a month.


Learn how…….

   
Back
Top