Find next empty row when adding new worksheet row in Excel - Dynamic Range

Hi,

Does anyone know how to check for an empty row when adding a new worksheet row in Excel?  Due to having to select the method of "Enter an ID manually" for a dynamic workbook ID, I'm faced with discovering how to advance the Range section to the next empty row when adding a new one.  I can see that I have mapping and formula ability in the Range inputs - but I'm uncertain what the RIGHT way is to do this.

 I've tried to place the module "MS Excel - List Worksheet Rows" before the "MS Excel - Add Worksheet Row", but that isn't yielding an output, even though it runs fine.   Not sure that's the right approach anyway.

Questions, comments, or accusations appreciated :slight_smile:.

Thanks!

Hi @cbarney ,

If your case is to only add new rows with values on the next empty row, the Add a Worksheet row module should work as this will automatically add a new row with data, just be sure to map the values from the previous/source module.

2 Likes