Good evening all.
I am not an expert by any stretch but I have been asked to help with what seems like a large spreadsheet to me. In this file there are several sheets that I need to pull the numbers from and put into 3 master sheets. So for example I'm using the formula =IF(Q6='Escobedo 1'!$A6,'Escobedo 1'!$B6,0)
The cell below that is =IF(Q6='Escobedo 2'!$A6,'Escobedo 2'!$B6,0), and so on down the line for at least 10 more sheets. I'm looking to be able to minimize the manual changing of values in each of these cells, and auto fill is not working for me as I would like. If I drag down All of the cell references are incremented. Does any one have any ideas how to proceed?
I am not an expert by any stretch but I have been asked to help with what seems like a large spreadsheet to me. In this file there are several sheets that I need to pull the numbers from and put into 3 master sheets. So for example I'm using the formula =IF(Q6='Escobedo 1'!$A6,'Escobedo 1'!$B6,0)
The cell below that is =IF(Q6='Escobedo 2'!$A6,'Escobedo 2'!$B6,0), and so on down the line for at least 10 more sheets. I'm looking to be able to minimize the manual changing of values in each of these cells, and auto fill is not working for me as I would like. If I drag down All of the cell references are incremented. Does any one have any ideas how to proceed?