I have a workbook that has multiple sheets based on the name of the business in order to keep track of how many RVU's each of our doctors read at each location. For the most part I've got most of the locations formatted correctly to that it is easy to populate a total. But I am having difficulty with one worksheet because it has to be laid out differently then the other sheets. The problem worksheet is titled BCC and the formulas that I have manually entered are on the worksheet titled BCC TOTAL. Basically, what I would like to do is enter some formula that would autmatically populate the Sum Total from BCC into the BCC total under for each doctor by date of service.
example;
See BCC TOTAL Column C dates 01/01/2011 - 02/28/2011. I manually entered each of the column C formulas.
Saturday C3 = BCC!C3
Sunday C5 = BCC!C4 (plus one row)
Monday C7 = BCC!C12 (plus 8 rows)
Tuesday C9 = BCC!C20 (plus 8 rows)
Wednesday C11 = BCC!C28 (plus 8 rows)
Thursday C13 = BCC!C36 (plus 8 rows)
Friday C15 = BCC!C44 (plus 8 rows)
Saturday C17 = BCC!C45 (plus one row)
Sunday C19 = BCC!C46 (plus one row)
Monday C21 = BCC!C54 (plus 8 rows)
Tuesday C23 = BCC!C62 (plus 8 rows)
Wednesday C25 = BCC!C70 (plus 8 rows)
Thursday C27 = BCC!C78 (plus 8 rows)
Friday C29 = BCC!C86 (plus 8 rows)
**that pattern continues for the entire month.
How do i write a formula that would populate those formulas without me having to type them all in? I can't drag to copy them becuase the worksheets aren't in the same format. And when I copy/paste the formula the cell references are wrong.
My workbook was too large so I only attached the two worksheets that I am having problems with.
Thank you so much for your time and help!!
Julia
Bookmarks