So, I've got some logs for a monthly deal. This whole spreadsheet consists of separate sheets (one for each day of the month) and a summary table.

Now, for one of the summary cells, I have this formula: ='1'!G17

This makes a call to one cell from the "Day 1" spreadsheet. Now, I've got to do this SAME cell for sheets 2-31 for the summary. If I copy and paste the formula down the list, excel trying to be smart, makes it go:

='1'!G17

='1'!G18

='1'!G19

and so on. That's obviously not what I need. I need excel to go down the list like this:

='1'!G17

='2'!G17

='3'!G17

='4'!G17

and so on.

Any ideas? I can go at my current rate, but I'm looking at many more hours of work as there's about 10 calls per sheet and 31 days. It adds up.

Now, for one of the summary cells, I have this formula: ='1'!G17

This makes a call to one cell from the "Day 1" spreadsheet. Now, I've got to do this SAME cell for sheets 2-31 for the summary. If I copy and paste the formula down the list, excel trying to be smart, makes it go:

='1'!G17

='1'!G18

='1'!G19

and so on. That's obviously not what I need. I need excel to go down the list like this:

='1'!G17

='2'!G17

='3'!G17

='4'!G17

and so on.

Any ideas? I can go at my current rate, but I'm looking at many more hours of work as there's about 10 calls per sheet and 31 days. It adds up.

## Comment