Replies

I was trying to modify this formula to split my data as attached, but can not.
Understand I can still use text to column which not my first preference.

Any helps would be appreciated,

kind regards

apologize, please ignore, it was the format
regards,

I usually go to menu Report –> Acc tax –> Transaction detail, and just select “Modify report” on tab “Display”, you can select what column to display so your report will look like raw database that ready to export to excel where you can manipulate as you want. I used to include column Transaction Number, based on that I can easily filter and delete un necessary raw related with subtotals and else. To include all transaction, go to “Filter” tabs and select all account

to export, just go to menu “export” and on tab “advance” you can eliminate such as subtotalling and anyelse which you can do also later in excel,

regards

Indra

I am interested with this, I hope someone could elaborate with example, please..

thanks again Hans,

cheers

One more thing Hans, if date is 1-Jan-08 result of formulae is Jan-09 instead of Jan-08..
any thoughts?

Hans, It will takes sometime for me to understand the formulae. But the impotant things it really works!

Many many thanks

Indra

…. is there a way to change my ID becoming HansVII ?

I post real case, that have monthly closing period between Jan 21 to Feb 20 and so on for following period. I need to group transaction date in one period in separate column so I could create report per month of period transaction.

I try with if formulae, but limited only for 8 month of period grouping, which I need 12 per year or more if the data pass through different year

regards

Indra

It is great Hans, Melanie, I add in to my makro collection

Rudi,

it’s been minutes, I am still laughing…

hue.he.he… you guys are great
at the time I was so hard try to find out – of course with my capacity, untill remember I did post in this forum

Very sorry ya, Hans.. : (

cheers

Indra

Thanks bunch Hanks,

Indra

Thanks Dr. Hans, Dr Jerry,
prescription works, as usual.

Indra

Ya Steve, I am hoping probably there are vba code to solve

regards

I tried your suggestion
– HTML –> when try to saving back to excel, file type does not appears in option
– with macros –> this time does not work, assuming my workbook doesnot have unused format/column/row
– Jan Karel’s tip –> it does work, but my workbook has many different formula to be named, at the middle of doing, seems not efficient – actually I think there should be a way (that I do not know) tip to define name efficiently
– VBA leaner – my workbook only has 1 simple code, no need to be cleaned

thanks anyway

Indra