A Microsoft Office (Excel, Word) forum. OfficeFrustration

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 » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

What function would I create?



 
 
Thread Tools Display Modes
  #1  
Old March 11th, 2005, 03:07 PM
pookie1394
external usenet poster
 
Posts: n/a
Default What function would I create?

dI have created an invoice where I input information for more than 1
provider. I have "Provider" and "Hours". I also have linked certain cells
with other cells in the invoice. The first page is the Summary of all
charges, with the second page detailing the charges. How do I have it so that
XXX's number of hours links to the correct cell on the first page summary?
E.g., XXX is the provider, with 5.0 hours.
XYZ, is another provider with 2.25 hours. I may have multiple entries for
each provider on the details page. How can the running total link to the
summary page where I have each providers row with total number of hours for
each times their hourly charge? So basically I am asking if I input a
particular person in provider and the hours worked for that day, how can I
link it to the summary page as a running total?
 




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 Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Create function to view hidden text only guido.deridder General Discussion 1 January 31st, 2005 04:00 PM
Help with VBA replace function Chris Crook General Discussion 1 November 24th, 2004 07:30 PM
Can I create a function in Excel? Jose General Discussion 3 July 22nd, 2004 07:36 PM
Need a DAYSINMONTH function to create a sales pace spreadsheet MOTOGEEK Worksheet Functions 4 April 12th, 2004 05:52 PM


All times are GMT +1. The time now is 12:38 AM.


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