Hello everyone.
I know this is a simple solution, However, my brain has turn to oatmeal I cannot remember how to do this nor can I find it anywhere.
I have a summary sheet that pulls in data from the source sheets. All of the cells where the data is found is the same on each sheet. I need the summary sheet to look up the the property code, then look to that worksheet (named as the property code) then retrieve data from a specific cell from that sheet.
The sheets in question change, based on outstanding balances, month to month so manually assigning an equal (=) command to each sheet/cell is time consuming. I would be very happy if I could drop a list of property codes into the summary and have all the data pulled in for calculations.
that is it in a nut shell.
Thanks in advance
I know this is a simple solution, However, my brain has turn to oatmeal I cannot remember how to do this nor can I find it anywhere.
I have a summary sheet that pulls in data from the source sheets. All of the cells where the data is found is the same on each sheet. I need the summary sheet to look up the the property code, then look to that worksheet (named as the property code) then retrieve data from a specific cell from that sheet.
The sheets in question change, based on outstanding balances, month to month so manually assigning an equal (=) command to each sheet/cell is time consuming. I would be very happy if I could drop a list of property codes into the summary and have all the data pulled in for calculations.
that is it in a nut shell.
Thanks in advance
