Related Posts
Diwali gift scene at GDS??
Tagline for award shows post COVID
Additional Posts in Excel Genius
why is index match superior to vlookup?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.




To do that properly you’d need to use VBA. I would code it as a Worksheet_Change event.
https://www.excel-easy.com/vba/events.html
If table rows are the only populated cells in th columns: =counta(a:a) , you may want to subtract 1 to adjust for the title row.
Otherwise in vba:
Sub xxx
i=1 'table starting row #
count=0
while(not(isempty(cells(i,1))))
Count=count+1
i=i+1
Wend
End sub
You can do this without vba by using conditional formatting and lookups paired to town number
Row* sorry
Can you not format as an Excel Table, which is a dynamic structure anyway? What is the use case?
Like I want to ask an user how many categories (rows) are needed for one section and change the rows within this section accordingly. Each category (row) will require further input.