Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 131
  • Last Modified:

Quick ways to clean up data downloaded into Excel from accounting programme?

hi Folks
Often when data is downloaded from Quickbooks/Sage into Excel it's usually got lots of merged cells, extra columns, extra rows etc...any suggestions on how to quickly clean them out to get the data in clean Excel list format i.e. no blank rows, no blank columns. Thanks
0
agwalsh
Asked:
agwalsh
  • 2
  • 2
  • 2
2 Solutions
 
QlemoC++ DeveloperCommented:
The most obvious way is to record a macro doing the work:
go to cell A1
shift ctrl csrdown
shift ctrl csrright
cell format: ...
0
 
John HurstBusiness Consultant (Owner)Commented:
When I use QuickBooks, I try to make sure the report does not include superfluous data and then that limits the extra rows and columns. It generally is not a problem.

Try the Transaction Summary Report which is more geared to a data dump.
0
 
agwalshAuthor Commented:
@Qlemo - thanks for that...any idea where I'd get the code to do that...and I'll pass it on.
@John Hurst - will suggest that to the person...
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
QlemoC++ DeveloperCommented:
"Record a macro" - start the macro recorder, and perform the necessary actions. This creates VBA code (with a lot of overhead, but working).
0
 
agwalshAuthor Commented:
Both good suggestions but John Hurst's answer a better fit for my specific question.
0
 
John HurstBusiness Consultant (Owner)Commented:
@agwalsh  - Thank you for the update and I was happy to help;
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now