my profile | my password | search | faq & rules | forum home

» Film-Tech Forum ARCHIVE   » Community   » Film-Yak   » Excel (spreadsheet) question

Author Topic: Excel (spreadsheet) question Mike Blakesley Film God Posts: 12767 From: Forsyth, Montana Registered: Jun 99 posted 09-26-2006 09:31 PM                        Are there any Excel users on here? There must be. I'm building a simple receipt for my day job. What I want to do is make the receipt form on sheet 1, and be able to click a button to print that receipt, then clear the figures from it and apply the totals to a running total on sheet 2. I know how to do all of it except the part in italics. I'm sure there is a simple way to do this but I've scoured the "help" file and can't find it. Ideas would be appreciated. Go ahead make me feel stupid for not thinking of it myself. (In Excel I'm an "advanced beginner" at best.) Thanks in advance for any help. EDIT: Never mind, I just figured it out. I was searching for "running total" and "running calculation" etc. and was going down the wrong road....I needed to allow circular references and "iterations" to get the proper results in my "totals" area, so there it is. I guess you mods can delete this if you want....I think it helped for me to post it here, just got my thought process rolling a different way. [ 09-26-2006, 10:54 PM: Message edited by: Mike Blakesley ]  |  IP: Logged Dave Williams Wet nipple scene Posts: 1836 From: Salt Lake City, UT, USA Registered: Jan 2000 posted 09-27-2006 01:06 AM                        That's the trick to Microsoft programs. They are way overcomplicated and overwritten, and as a result, cause us to overthink what we are looking for. When it comes to microsoft, first overthink, then act dumb, and the answer will almost always just make itself appear. Ciao  |  IP: Logged Phil Hill I love my cootie bug Posts: 7595 From: Hollywood, CA USA Registered: Mar 2000 posted 09-27-2006 07:21 PM                  Not your post Mike, but Dave's reply...  |  IP: Logged Joe Redifer You need a beating today Posts: 12859 From: Denver, Colorado Registered: May 99 posted 09-27-2006 07:30 PM                        Phil's reply =  |  IP: Logged Phil Hill I love my cootie bug Posts: 7595 From: Hollywood, CA USA Registered: Mar 2000 posted 09-27-2006 07:34 PM                  Joe = Funny! I LUV'd IT! (I bet your a MAC guy...and NOT in tune with the biz world. )  |  IP: Logged Dave Williams Wet nipple scene Posts: 1836 From: Salt Lake City, UT, USA Registered: Jan 2000 posted 09-28-2006 02:29 AM                        So just because I didn't call Mike a dumb ass whore and deminish his existence, therefore I am boring? Or is it that I am just boring in general, because that I can accept. Ciao  |  IP: Logged Phil Hill I love my cootie bug Posts: 7595 From: Hollywood, CA USA Registered: Mar 2000 posted 09-28-2006 02:52 AM                  Hmmmm... I was referring to your comments about Microsoft. Mike was only asking for some specific help, not a lecture. Duh...  |  IP: Logged Brad Miller Administrator Posts: 17775 From: Plano, TX (36.2 miles NW of Rockwall) Registered: May 99 posted 09-28-2006 02:59 AM                     Ya know Phil, I've got to agree with Joe here... Mike made his post at 9:31pm, then edited it at 10:54pm saying he figured it out. Dave made his post at 1:06am later that night, so at that point does it really matter? Of course I now get to tease Mike for not posting HOW he did this for the archives.  |  IP: Logged Phil Hill I love my cootie bug Posts: 7595 From: Hollywood, CA USA Registered: Mar 2000 posted 09-28-2006 03:10 AM                  oh... Ummm...ahhh...I humbly apologize to Joe, Dave, and to all including JFC since I was too stupid to read the time stamps to know what Joe was referring to.. GD time stamps! I guess I'll now have to pay attention to THOSE now too, rather than "just reading" a post. (But it's STILL a lecture!)  |  IP: Logged Joe Redifer You need a beating today Posts: 12859 From: Denver, Colorado Registered: May 99 posted 09-28-2006 09:25 AM                        Phil =  |  IP: Logged Mike Blakesley Film God Posts: 12767 From: Forsyth, Montana Registered: Jun 99 posted 09-28-2006 01:39 PM                        Wow, this must be the most times songwriter Paul Williams' picture has been posted on the internet in one day! And quite a coincidence too, because I watched some old "Match Game" clips on YouTube just the other night. Funny stuff! quote: Brad Miller HOW he did this for the archives. The thread was more fun talking about how boring Phil and Joe are, but as for how I did it, basically you just go into the Options and select "allow circular references." This allows you to put a formula such as "=A1 + B1" into cell A1, with the result that every time you type a new number into B1 it is added onto A1, giving you a running total of whatever happens in B1.  |  IP: Logged Tim Reed Better Projection Pays Posts: 5246 From: Northampton, PA Registered: Sep 1999 posted 09-28-2006 01:41 PM                       Funny guys, all o' yous.  |  IP: Logged

All times are Central (GMT -6:00)

Printer-friendly view of this topic

Hop To: Select a Forum: Category: Operations -------------------- Digital Cinema Forum Film Handlers' Forum Large Format Forum Ground Level Feature Info, Trailer Attachments & REAL Credit Offsets Category: Community -------------------- Film-Yak Film Handlers' Movie Reviews The Afterlife Bob Maar's Joke-A-Thon Category: Classified -------------------- Equipment and Supplies Wanted/For Sale Help Wanted/Seeking Employment Category: System -------------------- Software Beta Testing Forum

The Film-Tech Forums are designed for various members related to the cinema industry to express their opinions, viewpoints and testimonials on various products, services and events based upon speculation, personal knowledge and factual information through use, therefore all views represented here allow no liability upon the publishers of this web site and the owners of said views assume no liability for any ill will resulting from these postings. The posts made here are for educational as well as entertainment purposes and as such anyone viewing this portion of the website must accept these views as statements of the author of that opinion and agrees to release the authors from any and all liability.