Creation of Blank row and Addition of selected cells

Dshukla

Hi Team,

I am working to automate a attached sheet , and i want to add a blank row beneath row 130 and add the balances of accounts from 6 series to 8 series from column a to produce a output in row 132. Kindly help me with the resolution. 

i am attaching a sheet with desired output in Row 132.

Book1.xlsx

jrlindem

@Dshukla 

Here's an example that goes along with my Option #1 from the previous post.  I built this out to illustrate each component of what you need to do.  This is not necessarily the efficient use of tools (you could probably consolidate) but it's built to show the concepts separately from each other to help teach the technique:

The workflow is also attached.  Let me know if you have any questions about it.  Otherwise, I hope this helps you along.  -Jay

jrlindem_example.yxmd