Transforming database with formulas...

vaxo
4StarLounger
Posts: 432
Joined: 23 Mar 2017, 19:51

Transforming database with formulas...

Post by vaxo »

Hello Friends, I need help I have large accounting database which need to transformed like explained in Excel file, Please Help.

Thanks in advanced,
You do not have the required permissions to view the files attached to this post.
Top
snb
4StarLounger
Posts: 575
Joined: 14 Nov 2012, 16:06

Re: Transforming database with formulas...

Post by snb »

I'd use a simple pivottable in tabular form.
Top
User avatar
HansV
Administrator
Posts: 78485
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Transforming database with formulas...

Post by HansV »

Here is a macro solution:

Transforming Database with formula.xlsm
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Top
vaxo
4StarLounger
Posts: 432
Joined: 23 Mar 2017, 19:51

Re: Transforming database with formulas...

Post by vaxo »

Thanks.
Top

Return to “Excel and other spreadsheet applications”