Standard Finishing
4Over

Announcement

Collapse
No announcement yet.

.xls spread sheet

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • .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.

  • #2
    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

    Comment


    • #3
      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!

      Comment

      UltimateDuploSmartsoft (Presswise)Standard FinishingKBA4Over
      UltimateDuploStandard FinishingKBAKBA GTIChili publish4Over

      What's Going On

      Collapse

      There are currently 4540 users online. 105 members and 4435 guests.

      Most users ever online was 6,151 at 11:36 AM on 11-17-2017.

      Working...
      X