I have a scenario here in my process.
I have a data in sheet1 grouped with section(A,B,C) and I have data in other sheet2 grouped with section AB.
Now I need to copy the data from sheet 2 of sectionA and paste it in sheet1 below the sectionA and above sectionB criteria.
Manually we can do it by counting no.of rows and insert rows and paste data.
But with BOT how can i do it ? and the same follows with section B. I need to copy section B data and paste to sheet1 after section B and above to sectionC.
Expecting-My write range should work like - when I copy data from sheet2 and paste in sheet1 the rows below it should go down automatically.
So that the newly pasted data will no over-write the existing below rows data.
Can anyone suggest an approach where we can paste data below to our requried rows as new rows and not overwriting new data?
thanks in Advance.