Reverse Dynamic Range

[DatMatt]

I understand dynamic range to be a name for a range that Excel would recognize ("Inbound" for example might tell Excel to reference A1:A30) Is there a way however, to get Excel to dynamically change the range by using keywords? For example, without manually selecting A1:A30, could I get Excel to look for "inbound" in one cell, then find a second occurance (which moves daily) down the column to conclude the range? I fear macros, so I can't use VBA. Also, can I tally a keyword within the range and have Excel both number and
SUM the findings within this "reverse dynamic" range in the neighbouring column?

 

[Aladin Akyurek]

Sorry, IDK how. I see no way to attach a file or upload a screenshot.

Try MrExcel HTML Maker or Borders-Copy-Paste.

 

[DatMatt]

Thanks. I shall certainly give this a try when I get home today. I probably won't post till late tonite.