ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I transfer data to excel from database (https://www.excelbanter.com/excel-worksheet-functions/121094-how-do-i-transfer-data-excel-database.html)

ashu

How do I transfer data to excel from database
 
The following values are taken from excel-based database, where the actual
#'s are in millions. For reporting purpose, the actual values are divided by
1,000,000 & formatted with 1 decimal (i.e. 1,230,000 = 1.2). My issue is that
the total revenue is also pulled directly from the database & is not a sum.
As you can see due to rounding my revenue does NOT foot down. I need to be
able to tie back to database values. How can this be achieved without a lot
of manual effort (i.e. adding in 0.1's everywhere). Please advice.

Lease Income = 30.0
Interest Income = 3.1
Rmktg Income = 25.7
Fee Income = 2.9
Net Gain = 3.1
Other Income = 1.0
Total Revenue = 65.9



All times are GMT +1. The time now is 12:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com