Hello all,
Basically what I want to do is
What the code do is that it collect data from 3 or more sheets and insert them to another sheet in order to create an invoice. So far , so good.
FORMA sheet has only the below lines as shown in image 1
1.jpg
For example I need to add 20 products (20 rows) but I only have one free row , the starting row 15.
Then the script to automatically add 19 more rows but keep rows 16-21 (the last 5) untouched as they needed for the totals. So the totals will start at row 36 and rows 15-35 will be filled with data from other sheets. Finally the addedd row will need to have the formula in column D.
So need to always add more rows depending the amount of products collected from other sheets, not delete the last 5 rows but "push" them down.
I have attached a sample worksheet
Thank you all!
Also posted at https://forum.ozgrid.com/forum/index...row-if-needed/ and https://www.mrexcel.com/board/thread...eeded.1198559/
Bookmarks