Hi everyone
I have searched a lot, but with any luck .. I wish Success and good fortune be with you
I have posted the same request at this link but didn't work for me
http://www.vbaexpress.com/forum/show...061#post365061
I have data starting at row 8
The attachment is simply to transfer the data from the main sheet to two sheets ( Yes & no ) depending on the two condition in columns 31 and 32 and the code is working well ... and I need to insert six rows after each 30 names in two sheets (yes & no) These rows will serve as totals and footer
I have highlighted the points where I would like to insert the rows
if the remain items is less than 30 then to insert rows directly after them
During that process I would like to add some strings in these inserted lines
in the first inserted row To create the totals formulas and the formatting
in the second inserted row type : "Signature" in column C and in column E: "Signature" and in column H: "Signature"
in the third inserted row type : "Auditor" in column C and in column E: "Head of Accounts" and in column H: "General Manager"
in the six inserted row To create the previous totals and the formatting
With adjust the vertical and horizontal page breaks automatically
- Note For the four footer rows that Between the tables, I need to insert rows without borders
- Important Note : the original data is about 10,000 rows so I am searching for faster way for this task
I hope the idea is clear ... Please have a look at the example
How can I modify my code to proceed with this?
Your help is greatly appreciated
Thanks advanced for help