Can someone tell me how to move formulas and data from one sheet to another and have the formulas still function on the second sheet?
I have been using COUNTIF function to calculate totals from columns and rows on a sheet. I want to move the formulas (to include the calculated data) to a second sheet in the same workbook. I want the formula that will now be on the second sheet to keep calculating the data from the rows and columns from the first sheet. I will be adding data daily.
The block of formulas span 6 rows and 6 columns, with headers across the top of the columns and down the beginning of the rows.
Thanks for the help!
Bookmarks