joel_fluit
New Member
- Joined
- Mar 21, 2011
- Messages
- 1
Hello Everyone,
I have Worksheet 1(TB) that is a trial balance; Column A, Column B, Column C (Account #), Column D (Account Desc.), and Column E (Account Value). This is created using an import of a csv file and has +/- values in Column E.
Worksheet 2 (Groupings) has 3 Columns; A (Account #), B (Account Desc.), and C (Account Value). This is a sheet that has all of the accounts from TB and many many more. The Account Value is returned to the Groupings worksheet from the TB worksheet using a vlookup formula. If the account doesn't exist in the TB worksheet then 0 is displayed. What this worksheet is doing is just puting the accounts in the proper group. Between these groups is the total for the group and a row to seperate the groups.
What I want to do is make is so that in the Groupings if the account is 0 then the row is hidden, and if the group total is zero the it is all hidden. If I just use a filter then the spaces are left and I get large blank spaces between groups. These are large, like 100 pages. Also I need it to auto-update if an account value changes (import a new trial balance). I am new to macros so go easy on me. Thanks for your help!
I have Worksheet 1(TB) that is a trial balance; Column A, Column B, Column C (Account #), Column D (Account Desc.), and Column E (Account Value). This is created using an import of a csv file and has +/- values in Column E.
Worksheet 2 (Groupings) has 3 Columns; A (Account #), B (Account Desc.), and C (Account Value). This is a sheet that has all of the accounts from TB and many many more. The Account Value is returned to the Groupings worksheet from the TB worksheet using a vlookup formula. If the account doesn't exist in the TB worksheet then 0 is displayed. What this worksheet is doing is just puting the accounts in the proper group. Between these groups is the total for the group and a row to seperate the groups.
What I want to do is make is so that in the Groupings if the account is 0 then the row is hidden, and if the group total is zero the it is all hidden. If I just use a filter then the spaces are left and I get large blank spaces between groups. These are large, like 100 pages. Also I need it to auto-update if an account value changes (import a new trial balance). I am new to macros so go easy on me. Thanks for your help!
