Hello Friends, I need help I have large accounting database which need to transformed like explained in Excel file, Please Help.
Thanks in advanced,
Transforming database with formulas...
-
- 4StarLounger
- Posts: 432
- Joined: 23 Mar 2017, 19:51
Transforming database with formulas...
You do not have the required permissions to view the files attached to this post.
-
- 4StarLounger
- Posts: 587
- Joined: 14 Nov 2012, 16:06
Re: Transforming database with formulas...
I'd use a simple pivottable in tabular form.
-
- Administrator
- Posts: 78585
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Transforming database with formulas...
Here is a macro solution:
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 432
- Joined: 23 Mar 2017, 19:51