| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill Down
Hi I have a list: cell a1:J1 CELL A2:J1 CELL A3: (bLANK) CELL A4: J2 CELL A5: (BLANK) A6: J12 A7: J12 A8: J12 A9: (BLANK) ETC.ETC. I have 2000 rows of this nature, I need a fill down so that in the above for example A3 WILL BE J1, A WILL BE J2 and A9 will be J12. etc. Thank -- T De Villier ----------------------------------------------------------------------- T De Villiers's Profile: http://www.excelforum.com/member.php...fo&userid=2647 View this thread: http://www.excelforum.com/showthread.php?threadid=56244 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Fill Down
http://www.contextures.com/xlDataEntry02.html great site bt -- MDubbelboe ----------------------------------------------------------------------- MDubbelboer's Profile: http://www.excelforum.com/member.php...fo&userid=3633 View this thread: http://www.excelforum.com/showthread.php?threadid=56244 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what is the alternative for PlotArea.Fill. Fill property is hidden | New Users to Excel | |||
| Erase fill print then bring fill back | Excel Discussion (Misc queries) | |||
| Some formulas don't track copies, pastes, fill right, fill down | Excel Discussion (Misc queries) | |||
| Fill in form to type Item descrictions and costs and fill in funct | Excel Worksheet Functions | |||
| I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
![T De Villiers[_35_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
