Adding rows automatically in two separate worksheets

**drakaz** · 03-14-2013, 03:03 AM

Hi,

Going straight to the point, this is the situaton:
I want to make a worksheet that combines few different worksheet's into one (added an example). However, I cannot think of a way to make the main worksheet (Full Balance Sheet in example) to be feeded information which is added later, in assets, liabs or equity worksheets.

As Assets, Liabilities and Equity worksheet's will be modified constantly, I would like that this automatically would feed into Full Balance Sheet. Rows can be added in between, for ex. between ''Land'' and ''Buildings'', and in the end, for example after "Other tangable assets". Every row will probably have formula in it, so not losing it is also important.

Now that I look at it, I should have posted this thread in Excel Programming / VBA / Macros section, as I cannot find an easy way to come arround this problem with simple formulas.

Thank you in advance for your assistance.

Regards,
drakaz

**aydeegee** · 03-14-2013, 06:37 PM

I may be missing somwthing here, but it seems that you already have the solution? If you update Assets cell B4, this changes Full Balance Sheet B4. You do not say where the information that goes into the supporting sheets comes from. I am assuming that information goes into the supporting schedules and then goes to the Full Balance Sheet.

If I am wrong and the information goes from the Full Balance sheet, then again, where does this information come from? Why have separate sheets - could you not just use different print areas?

Regards

Alastair

**arlu1201** · 04-29-2013, 08:45 AM

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.