Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 22nd 05, 09:55 PM posted to microsoft.public.excel.worksheet.functions
mstangel
 
Posts: n/a
Default Formula questions

I have a worksheet for the cell phone charges of each of our employees.It has
a row of months across the top and a column of names down the left side. The
montly charges are entered into the cell under the appropriate month for each
employee. What I need is a formula to generate a report on a different
sheet. This report needs to have the employees name and only the current
monthly charge listed, as well as the subtotaled amount below of all the
employees in a particular cost center. I can link the data in the cells
together for the first months entry (example A2 in sheet1 is linked to the
selected cell in sheet2) , but I can't figure out how to make it work for the
next months data( B2) without creating a new report or changing the formula
each time..

  #2   Report Post  
Old November 22nd 05, 10:16 PM posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default Formula questions

Hi

On sheet2, copy the whole of column A from Sheet1, to cell A2
This will give you a blank row 1 and a list of all the employees from A2 to
say A100
In cell B1 enter the Month number required.
In cell B2 enter
=VLOOKUP(A2,Sheet1!$A$1:$A$100,$B$1+1,0)
Copy the formula down column B.
Just changing the month number in B1 will change the set of values retrieved.
Carry out your totaling and sub-totaling accordingly.

Regards

Roger Govier


mstangel wrote:
I have a worksheet for the cell phone charges of each of our employees.It has
a row of months across the top and a column of names down the left side. The
montly charges are entered into the cell under the appropriate month for each
employee. What I need is a formula to generate a report on a different
sheet. This report needs to have the employees name and only the current
monthly charge listed, as well as the subtotaled amount below of all the
employees in a particular cost center. I can link the data in the cells
together for the first months entry (example A2 in sheet1 is linked to the
selected cell in sheet2) , but I can't figure out how to make it work for the
next months data( B2) without creating a new report or changing the formula
each time..



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
Array formula returning wrong results TUNGANA KURMA RAJU Excel Discussion (Misc queries) 1 November 19th 05 10:29 AM
self-updating formula BorisS Excel Discussion (Misc queries) 3 November 17th 05 01:13 PM
adding row to forumla carrera Excel Discussion (Misc queries) 9 August 23rd 05 10:24 PM
Problem with VBA returning the contents of a long formula. [email protected] Excel Discussion (Misc queries) 2 February 23rd 05 12:14 AM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 03:13 PM


All times are GMT +1. The time now is 05:51 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017