Trial Balance extract - VBA

[Excel_Pa]

Hi All,

I need macro to extract this information to respective sheets using "Account Type".
Example:
Copy from Sheet "Trial Balance" A2 value, Paste to Sheet "Balance Sheet" A20 cell
Copy from Sheet "Trial Balance" A6 value, Paste to Sheet "Profit and Loss" A2 cell

Like wise I need to extract values from A2 to A47 to respective sheets i.e., Profit and Loss & Balance Sheet

TB.xls

Thanks in advance

[candybg]

I think you should be able to do this without macros.
For example, in A20 you will type:
=A2
This will "pull" the value in A2 into A20 and every time A2 is changed, A20 will also change automatically.

Will this help you?

[Alf]

Perhaps something like this could be of use?

To test run macro “SortData”

As the macro uses autofilter to extract data I’ve used the formula “=SUBTOTAL(9,C2:C48) “ and “=SUBTOTAL(9,D2:D48)” in sheet “Trial Balance” as this formula will give me the sum of the visible rows when using autofilter.

Macro start by clearing sheets “Profit and loss” and “Balance Sheet” and then it set up an autofilter for every case i.e. “Income”, Expense” and so forth.

Alf

[Excel_Pa]

I think you should be able to do this without macros.
For example, in A20 you will type:
=A2
This will "pull" the value in A2 into A20 and every time A2 is changed, A20 will also change automatically.

Will this help you?

Thanks Candyg for your help...

[Excel_Pa]

Perhaps something like this could be of use?

To test run macro “SortData”

As the macro uses autofilter to extract data I’ve used the formula “=SUBTOTAL(9,C2:C48) “ and “=SUBTOTAL(9,D2:D48)” in sheet “Trial Balance” as this formula will give me the sum of the visible rows when using autofilter.

Macro start by clearing sheets “Profit and loss” and “Balance Sheet” and then it set up an autofilter for every case i.e. “Income”, Expense” and so forth.

Alf

Thanks it worked exactly what I thought. Thanks for your help and saving my lot of time