| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically add a new row
I wanted to see if there is a way for me to insert a code in cell A1
that will look at cell B2 on another sheet and if there is data in cell B2 then it will automatically insert a new row under cell A1 and copy the formula in cell A1 into A2 and have the process repeated until no more information is available in column B. Thanks in advance for any assistance. -yalex --- Message posted from http://www.ExcelForum.com/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Automatically add a new row
What is the result you are trying to produce? If you want a simple
count of cells with information not including "B1" you can do this: =COUNTA(Sheet2!B:B) - 1 --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically add one row | Excel Discussion (Misc queries) | |||
| Automatically insert time in excel but not automatically updated | Excel Worksheet Functions | |||
| Number '8' changes to a '9' automatically | Excel Discussion (Misc queries) | |||
| Automatically Reference Tab Name | Excel Discussion (Misc queries) | |||
| St automatically changes to So | Excel Discussion (Misc queries) | |||
![yalex[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
