I have a function in B9 that looks like this
=COUNTIF('0308 Detail'!A:A,'0308 Detail'!A8)
How can I automatically repeat this same function through columns B10, B11, B12.... and increment certain values within the function?
Example
B10 would like
=COUNTIF('0309 Detail'!A:A,'0309 Detail'!A9)
B11 would look like
=COUNTIF('0310 Detail'!A:A,'0310 Detail'!A10)
and so on.....
Copying and pasting is just taking too long.
Thanks,
Greg
Bookmarks