Alliedassault

Alliedassault (alliedassault.us/index.php)
-   Offtopic (alliedassault.us/forumdisplay.php?f=13)
-   -   help with spreadsheets (alliedassault.us/showthread.php?t=49516)

elitecloud 11-20-2005 12:15 AM

help with spreadsheets
 
i use openoffice, which is the firefox of office

anyways, i use the spreadsheet program they have to calculate and keep track up tips me and my brother receive at work, so that after a month i can make a accurate deposit of said tips without having to count it all up again, which can be a helluva alot of ones

the way i have it now i have to manually change the dates, which is agrivating when you have to do it like 4 times, is there a way i can stream line this so i can make it quick and simple so it will put the dates in for me for the next month and so on

here is a picture of what i have, and why it's such a chore to change

http://img505.imageshack.us/my.php?imag ... eet3rf.jpg

thanks

Sniper101 11-20-2005 12:34 AM

i dont know how you would do it in this program, but in MS Excel its quite easy. however most programs like that are quite similar so create the first date, say 11/20 (excel converts it automatically to 20-Nov) and then select the cell. if you can grab the corner of the cell and drag it down, that might automatically create cronological dates fo you. if not see if your spread sheet program can read xls files (excel) and or save a file as an xls. if it can, PM me so i can get u my e-mail then you can send me the layout of it and ill send back the template

Short Hand 11-20-2005 02:02 AM

look for a auto sum button.....

elitecloud 11-21-2005 12:42 AM

works great, you guys pwn

thanks i really appreciate it

lock plz biggrin:

jujumantb 11-21-2005 01:15 AM

i spread your mom's sheet last night.

whos house?

RUN'S HOUSE!!!

TonyMontana 11-21-2005 01:16 AM

Quote:

Originally Posted by jujumantb
i spread your mom's sheet last night.

whos house?

RUN'S HOUSE!!!

happy:


All times are GMT -6. The time now is 04:33 PM.

Powered by vBulletin® Version 3.8.12 by ScriptzBin
Copyright ©2000 - 2025, vBulletin Solutions Inc.
© 1998 - 2007 by Rudedog Productions | All trademarks used are properties of their respective owners. All rights reserved.