Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 13th 17, 11:18 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2017
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

  #2   Report Post  
Old March 13th 17, 08:00 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 728
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   Report Post  
Old March 13th 17, 08:26 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 728
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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 04:38 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017