Jul 19 2021 09:55 AM
I'm trying to pull data from one sheet to another within a excel spreadsheet.
Example: formula is =+COUNTIF(JULY!$D2:E989,B3)
I need the calculating column to pull data from the 'July' tab always starting with column D2:E989 from 'JULY' tab.
I try to copy & paste the formula but it then auto calculates by changing each line
example; for each line it changes to
=+COUNTIF(JULY!$D3:E989,B3)
=+COUNTIF(JULY!$D4:E989,B3)
=+COUNTIF(JULY!$D5:E989,B3) etc...
How can I copy this formula to 618 lines without the formula changing?