Remember Me?

#1
November 22nd 05, 10:55 PM posted to microsoft.public.excel.worksheet.functions
 mstangel Posts: n/a
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
November 22nd 05, 11:16 PM posted to microsoft.public.excel.worksheet.functions
 Roger Govier Posts: n/a
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..

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post TUNGANA KURMA RAJU Excel Discussion (Misc queries) 1 November 19th 05 11:29 AM BorisS Excel Discussion (Misc queries) 3 November 17th 05 02:13 PM carrera Excel Discussion (Misc queries) 9 August 23rd 05 10:24 PM [email protected] Excel Discussion (Misc queries) 2 February 23rd 05 01:14 AM o0o0o0o Excel Worksheet Functions 6 November 19th 04 04:13 PM

All times are GMT +1. The time now is 04:59 PM.