Query result and formula
 

I have a select query which retruns data to excel sheet. But the
problem is excel sheet has formulas in between coulmns how can i
retain the formulas as it is and export data from the query.

Query
---------
Select name, a1, a2, b1, b2
from test

Excel Worksheet
-----------------
Name A1 A2 Total(Fromula:A1+A2) B1 B2 Total(Fromula:B1+B2)

How can i retain total formula?

Thanks
-Payal

Query result and formula
 

Hello Payal,

You are going to either have to separate the query into two, one for a1/a2
and one for b1/b2; or put the formulas on another sheet.

HTH, Greg

"Payal" wrote in message
om...
I have a select query which retruns data to excel sheet. But the
problem is excel sheet has formulas in between coulmns how can i
retain the formulas as it is and export data from the query.

Query
---------
Select name, a1, a2, b1, b2
from test

Excel Worksheet
-----------------
Name A1 A2 Total(Fromula:A1+A2) B1 B2 Total(Fromula:B1+B2)

How can i retain total formula?

Thanks
-Payal