Macro to place two tables

[romandotcom]

Hello,

I need help to place 2 tables in a spreadsheet. Referring to my attached excel spreadsheet, the company total has been placed in B23. Depending on Employee size it might go down, but it will remain in Column B. However, keeping 3 rows blank below "Company totals" the tables will appear.

My attached spreadsheet has the tables. It should be placed the exact format.

Please help to make this.

Thanks in advance.

[AliGW]

Fill in hour expected results, manually calculated.

[romandotcom]

Someone, please help.

[kvsrinivasamurthy]

What is the expected result in each cell. how to calculate . Manually show it in file.
Explain it in detail.

[romandotcom]

I have saved an excel spreadsheet, there is a table from row # 27 to row # 40. While I will run the macro, this row # 27-40 will be placed below Company totals after keeping 3 rows blank like the spreadsheet. Company Totals may appear in any row depending on the size of the employee. In this spreadsheet there are 12 employees. If there are 15 employees, then Company totals will be available in B26. If so, after running the macro the table will be placed after keeping 3 rows blank below Company Total.

Thanks so much