#16
|
|||
|
|||
Quote:
a58 is start cell a130 is end cell |
#17
|
|||
|
|||
.
Ok .. then paste the following in A58 : =IF(ISBLANK(B58)," ",COUNTA($B$58:B58)) Then follow the same instructions as before : Once you have the formula in the cell, click on the cell and a small dot will appear in the lower right hand corner of the cell. Hover your cursor over that tiny black dot until the cursor becomes a cross symbol. While it remains the cross, double click the dot. The formula should auto-fill all the cells in Col A that are adjacent to a cell in Col B that has some data. Be sure to delete the macro from the worksheet module. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Occurence appt invitees showing on entire series | doresa69 | Outlook | 0 | 11-11-2016 01:32 PM |
Series numbering | ericjowens | Excel | 2 | 09-03-2015 11:20 AM |
deleted items in wrong mailbox | Flip | Outlook | 2 | 03-12-2014 03:51 AM |
Header numbering is wrong | Scaffold | Word | 2 | 02-13-2014 03:08 AM |
Continue Auto Numbering Throughout Entire Presentation | craigfu | PowerPoint | 3 | 05-04-2012 05:42 AM |