ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Filling adjacent formulas with data import (https://www.excelbanter.com/excel-discussion-misc-queries/263903-filling-adjacent-formulas-data-import.html)

Dave

Filling adjacent formulas with data import
 
Hi all,
XL2003
2nd posting - first on ended up in the ether...
I've tried importing a .txt file (from the Data menu) with the "Fill down
formulas in columns adjacent to data" box ticked. But my formulas don't fill.
I've tried them on the left, and on the right (of the imported data), but no
progress. Can anyone tell me what I may be doing wrong?
Regards - Dave.

ozgrid.com

Filling adjacent formulas with data import
 
Double click the Fill Handle
http://www.ozgrid.com/Excel/excel-fill-handle.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Dave" wrote in message
...
Hi all,
XL2003
2nd posting - first on ended up in the ether...
I've tried importing a .txt file (from the Data menu) with the "Fill down
formulas in columns adjacent to data" box ticked. But my formulas don't
fill.
I've tried them on the left, and on the right (of the imported data), but
no
progress. Can anyone tell me what I may be doing wrong?
Regards - Dave.




All times are GMT +1. The time now is 05:42 AM.

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