LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
KC KC is offline
external usenet poster
 
Posts: 107
Default how to Export data from Quickbooks into formulated excel spreadshe

QB PRO 2002
Excel 2003

Every month I enter Credit card deposit data manually in a formulated SS.

I enter the same data when entering orders in QB. In QB I created a
customized sales report. It displays almost the same exact data as the
report above. The totals for each report have come up the same for the last
three months.

Unfortunately the Sales Report in QB can only display so much, the report
functionality is limited and there is no way to recreate the SS formt there.
We would like to be able to export the QB data into the exisitng formulated
excel SS. The SS report is more robust and has more detail.

I know I can export into a blank Excel SS, but what about formulated ones.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Numbers/Text data missing from excel to excel query? RAMAERTE Excel Discussion (Misc queries) 0 May 8th 06 05:05 PM
consolidation of tables in excel with text and figures samenvoegen van sheets Excel Worksheet Functions 8 March 2nd 06 03:27 PM
From several workbooks onto one excel worksheet steve Excel Discussion (Misc queries) 6 December 1st 05 08:03 AM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Can Excel Export Data to Word Format? Reddiance Excel Discussion (Misc queries) 2 April 18th 05 06:03 PM


All times are GMT +1. The time now is 04:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"