A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Floating cell with running total across multiple sheets



 
 
Thread Tools Display Modes
  #1  
Old March 13th 17, 11:18 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Floating cell with running total across multiple sheets

Hi everyone,

I have multiple clients that I keep time sheets for using Google Sheets. I am contracted for a certain number of hours per fortnight. However, during busy seasons I need to get the job done but keep a log of extra hours and then invoice for those hours later on and take time off in Lieu.

Each fortnight is set up as a seperate sheet with dates and hours logged as well as extra hours

I need to find a way to keep a running tally across all the sheets. A floating cell or two or frozen cell would be good, I just can't seem to find how to do it.

Is this possible? How???

Thanks in advance
Ads
  #2  
Old March 13th 17, 08:00 PM posted to microsoft.public.excel.worksheet.functions
GS[_6_]
external usenet poster
 
Posts: 717
Default Floating cell with running total across multiple sheets

> Hi everyone,
>
> I have multiple clients that I keep time sheets for using Google Sheets. I am
> contracted for a certain number of hours per fortnight. However, during busy
> seasons I need to get the job done but keep a log of extra hours and then
> invoice for those hours later on and take time off in Lieu.
>
> Each fortnight is set up as a seperate sheet with dates and hours logged as
> well as extra hours
>
> I need to find a way to keep a running tally across all the sheets. A
> floating cell or two or frozen cell would be good, I just can't seem to find
> how to do it.
>
> Is this possible? How???
>
> Thanks in advance


First off.., Google Sheets is not Excel! It will open Excel files (as well as
others) but its features are *very limited* to basics only. (At least, as far
as I've been able to determine from tests I've done with my own timesheet
templates)

We need you to post a link to a sample of your file to be able to determine the
best approach with whatever data layout you're using on each timesheet. Also,
the structure of the sheet is important in that it must be designed to
consolidate by way of formula only since macros are not supported.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
  #3  
Old March 13th 17, 08:26 PM posted to microsoft.public.excel.worksheet.functions
GS[_6_]
external usenet poster
 
Posts: 717
Default Floating cell with running total across multiple sheets

Note that whatever 'templates' we make for you in Excel, you'll have to
duplicate any features not 'automatically' recognized in GS. You may also want
to enable various 'add-ons' offered there. (Like "Power Tools", for example)

Note also that all data created in GS stays there! (Just saying)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with a running total on multiple sheets Shari C Excel Worksheet Functions 5 January 4th 13 06:08 AM
Running total between sheets [email protected] Excel Discussion (Misc queries) 3 January 24th 08 02:22 PM
Floating cell containing a "Running Total". Dantheman Excel Discussion (Misc queries) 2 June 27th 06 03:21 AM
running total from the same field on multiple sheets as i add she obviscator Excel Worksheet Functions 2 April 15th 06 06:34 PM
Floating Cell Total John Excel Programming 2 December 7th 03 05:38 AM


All times are GMT +1. The time now is 01:18 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.