The easy way to do this is to select the formula to copy double click the
fill handle
Don Guillett
SalesAid Software
dguille...@gmail.com
-----Original Message-----
From: Sumesh
Sent: Thursday, October 13, 2011 3:47 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ "fill down formulas in columns adjacent to data"
option in Excel 2007
Hi,
I'm using Excel 2007.
I'm exporting some data from Oracle DB2 database using the export data
functionality in Excel (Data - Get External Data - From Other Sources
- From Microsoft Query).
To the data so retrieved, I've added two more columns which contain
formula.
Whenever the data retrieved expands, I want the formulas to also be
copied to the new rows. This functionality was available in Excel
2003. I do not find this opton in Excel 2007.
Somebody please guide me.
Cheers,
Sumesh
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
