| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to Populate Cells
Right now I have several columns and in column "A" I want to populate
item numbers that are currently distributed throughout column "B". My problem is that in column "B" there are several blank rows between the items numbers. Ultimately what I want to do is if B3 to B5 are blank I want to populate A3 through A5 with the item number in B6. B6 is basically a Sub Total Row that has the Item #. Is there a logical formula to accomplish this or do I need a macro? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a formula to populate information from multiple cells in another workbook | Excel Worksheet Functions | |||
| Help! Formula that can Ref. hidden data & Populate Cells with desired text | Excel Worksheet Functions | |||
| how do populate empty cells with the contents of populated cells . | Excel Discussion (Misc queries) | |||
| Auto populate cells based on 2 cells division. | Excel Discussion (Misc queries) | |||
| How to populate formula in range of vertical cells to next colum | Excel Worksheet Functions | |||
Threaded Mode
