Hello all,
This is my first post to this forum but I want to introduce myself real quick to say hi. I am an Excel geek, and I absolutely love this website and all the insight I have obtained from it. Thanks in advance for helping me with this question:
I created a spreadsheet for my boss with two worksheets: the first worksheet is data for reports we get returned from each employee and from which month. I have that formatted so that you enter the date the report was originally issued and it shows as "2013-Mar" (for example). On the second worksheet I have set up a table with a COUNTIFS function to show employees in the columns and months in the rows, so that it automatically keeps track of how many reports are returned from each employee according to what months they were originally issued.
In the second worksheet, currently if I just copy the row and paste it on the row below, I have to manually change the date in the formula bar, which displays as "=5/1/2013". (The formula currently works so that all of the reports originally issued in May 2013 will be included in the calculation, and that is what I need). However, I am going to leave my position soon and I have to find a no-brainer way for my boss to figure out how to continue using this spreadsheet (which means I need to have copy/paste work without manual adjustments). Can anyone help me with this?
Bookmarks