Copying Formula Issue Advice - I'm SURE there is an easy answer I am overlooking

Done! THANK YOU!

THANK YOU! It appears to be off by one column somehow, meaning if I add values to loan principle for Warflield, it shows up as loan interest. The Property Mgmt fee shows up in loan principle.

Please re-read Post #4 more carefully - you should have put the formula in cell F3 of the Summary sheet, and then copied it across and down, whereas you put it into cell G3.

Hope this helps.

Pete

MY APOLOGIES! So sorry I put it in the wrong cell! THANK YOU for the help! I'd buy you a coffee if I could!!!!

Well, if that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post and mark this thread as SOLVED.

Also, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile), and it's a bit cheaper than a cup of coffee.

Pete

Would it be possible to give me a brief explanation of how this formula works? I really want to understand it. THANK YOU!!!!!

The INDIRECT function allows you to build up a string which is equivalent to a cell or range reference, and then passes it to Excel to be evaluated as if it were a proper cell or range reference. In your case, the sheet name can be found in cell A3 and the column you want to get the data from is always column P, However, you want to get data from P11, P12, P13 etc. (i.e. row-wise) as you copy the data across columns, so the COLUMN(K1) part will initially return 11 (as K is the 11th column), but then becomes COLUMN(L1), COLUMN(M1) etc. as the formula is copied across, so this term returns 11, 12, 13 etc. (i.e. the different rows that you want) in different columns.

So, the composite string is built up of:

("'"&$A3&"'!P"&COLUMN(K1))

which becomes:

("'"&"Carneal"&"'!P"&11)

or:

("'Carneal'!P11")

in the first cell. The sheet name varies as the formula is copied down, and the row reference changes as the formula is copied across.

Hope this helps.

Pete