Hello Forum.
I have been making accounting for my building for 7 years (unprofessionally)
I have my excel table that works fine but I have copied and pasted many formulas manually in all sheets.
+ instead of having tables that grow as expenses are entered, I created tables with 100 lines which makes it ugly when printing unused empty cells.
So I am trying to rewrite the whole thing.
I discovered the tables (better late then never) and when I hit TAB, it adds a new line before the total.
Neat.
Then I used a VBA formula to copy the table in the next row.
Thing is I want to copy the GLOBAL expenditure table to all sheets (7 sheets representing each apartment) but I would like the amount to be split according to the percentage held by each apartment owner
0_Form_Excel.png
I used a VBA to copy the expenditure table
Sub copedonnees()
Range("a14").CurrentRegion.Copy Feuil2.Range("a14")
End Sub
With this macro, I have a problem because my table of income will grow.
What I want to achieve:
1) to 'replicate the GLOBAL spending table on all sheets
2)To apply the individual percentage of the GLOBAL spending to each individual sheet.
Thank you
Eve
Bookmarks