Is there a way to display all data on each line of a report with splits?

srchase

I use Excel to further manipulate and report transaction data from Quicken. When I generate a Quicken transaction report that shows splits, the first entry for the split in the report contains data for the Date, Account and Description for the transaction. However, that information is missing from subsequent lines. When I export and copy that report to Excel, I have to then copy and paste the missing data from that first line of the split transaction to all the other lines for that transaction if I want to be able to sort on those fields in Excel. Depending on the size of the report this can be very time consuming and fraught with opportunity for error. I have not seen any option in Quicken that would cause that data to be included on every line so I'm looking at writing some VB script in Excel to automate the copy and paste of that data, but given that I'm no expert in writing VB code I'd prefer to get the data straight for Quicken.

Any guidance here?

Thanks!

Jim_Harman

There is no need for a new idea; this issue is covered here
https://community.quicken.com/discussion/comment/20067294

NotACPA

Nope, sorry, but other than using the Excel copy function, there's no way to do what you ask.

srchase

Thanks. Would like to ask for that as a feature enhancement!

Quicken Anja

Hello @srchase,

Thank you for taking the time to visit the Community.

srchase said:

Thanks. Would like to ask for that as a feature enhancement!

To request a new feature to be added in the future, what you can do is create an idea post. This way other users who have the same or a similar request can vote on your idea.

Our Development and Product teams frequently use our idea posts in order to improve Quicken and implement new features requested by customers. 

I hope this helps!

Jim_Harman

There is no need for a new idea; this issue is covered here
https://community.quicken.com/discussion/comment/20067294

srchase

Just when I thought I knew a bit about Excel, I learn a new trick. Thank you to this Community for the lightning fast responses and for pointing me to a solution. Much appreciated!