On Thursday, April 17, 2008 1:48:01 PM UTC-5, JOJO193 wrote:
I am trying to auto fill a sheetreference.

Right now I have ='Loan 37'!$G$14 and want excel to copy down ='Loan
38'!$G$14,='Loan 39'!$G$14 , ='Loan 40'!$G$14, and so on. Excel does not
recognize the pattern. How do I get it to do this?

Thanks

I'm trying something similar, if you can help please let me know.

Ok, I'm making an invoice tracker, I use a template to create the invoices and I fill in and name each sheet the invoice # ex. IN12345 (and I place the name of the invoice into the sheet in cell A1). I keep all of these invoices in a folder labeled invoices. I need to get certain info off of them and placed on a common sheet. I need the spreadsheet I'm making to auto populate the info each time I drop a new invoice in the invoice folder. I can't get it to change the invoice # automatically. I can paste the formulas all the way down.

Also I have a range of cells that I need it to sum in addition to change the reference of the name of the sheet.

I also need a column in this tracker to update the date of which the line row was added to the sheet.

Any help is highly appreciated!