Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill down with references to worksheets
There are a number of posts on this subject, but I couldn't find
exactly what I was looking for! I have a workbook with a number of invoices, all the same format, one on each worksheet. The worksheets have the same number as the invoice and are numbered sequentially (35, 36, 37 etc). I have a summary sheet that has one line per invoice and shows invoice number, date, total etc. Can I use Fill Down to copy formulae such as ='23'!H$2 so they increment from row to row to ='24'!H$2, ='25'!H$2 etc? If so, how do I go about it? Thanks in advance! Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill Data with formulas with Absolute References | Excel Discussion (Misc queries) | |||
References between worksheets using IF | Excel Worksheet Functions | |||
References to worksheets in formulae | Excel Discussion (Misc queries) | |||
Auto Fill with some references locked | Excel Discussion (Misc queries) | |||
Lock or Unlock cell references in a formula for auto fill purposes | Excel Discussion (Misc queries) |