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..