| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto fill references
Another question: Main sheet has list of values in col A starting with A2, e.g. AAL ABF ABG I want to create a reference so that cell A1 in Sheet 2 of the workboo links to A2 in the Main sheet, i.e. "AAL". A1 in Sheet 3 would link t A3 in the Main sheet, i.e. "ABF", and so on. Given that there are 300 sheets, I don't want to do this manually. If any of you can help, I' really appreciate it. Bertie -- claytor ----------------------------------------------------------------------- claytorm's Profile: http://www.excelforum.com/member.php...fo&userid=1161 View this thread: http://www.excelforum.com/showthread.php?threadid=48024 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill down with references to worksheets | Excel Worksheet Functions | |||
| Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
| Auto Fill with some references locked | Excel Discussion (Misc queries) | |||
| using auto fill edit or fill handel | Excel Worksheet Functions | |||
| Lock or Unlock cell references in a formula for auto fill purposes | Excel Discussion (Misc queries) | |||
![claytorm[_14_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
