ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   formulas and new rows (https://www.excelbanter.com/new-users-excel/59732-formulas-new-rows.html)

mango7

formulas and new rows
 

how do i get excel to automatically add my formula to new rows in a
certain column. Excel 2002


--
mango7
------------------------------------------------------------------------
mango7's Profile: http://www.excelforum.com/member.php...o&userid=29529
View this thread: http://www.excelforum.com/showthread...hreadid=492306


zarir kalian

formulas and new rows
 
Hi:
I just joined and did not know how to send a new message can someone show me.
I have a question on written a formula which someone sent me and want to
know how they made the formula
This is what they wrote:
http://stockcharts.com/def/servlet/SC.web?c= SIZ ,uu[l,a]daclyyay[pb50!b20][vc60][iLe12,26,9!Ll14]&pref=G


Please help
Regards
Zarir







"mango7" wrote:


how do i get excel to automatically add my formula to new rows in a
certain column. Excel 2002


--
mango7
------------------------------------------------------------------------
mango7's Profile:
http://www.excelforum.com/member.php...o&userid=29529
View this thread: http://www.excelforum.com/showthread...hreadid=492306



Don Guillett

formulas and new rows
 
Te first part is the url and the bracketed parts are variables to the
standard url.

Go here
http://stockcharts.com/def/servlet/SC.web?c=ibm
click on update chart and you get
http://stockcharts.com/def/servlet/SC.web?c=IBM,uu[m,a]daclyyay[pb50!b200][vc60][iUb14!La12,26,9]&pref=G
--
Don Guillett
SalesAid Software

"zarir kalian" <zarir
wrote in message
...
Hi:
I just joined and did not know how to send a new message can someone show
me.
I have a question on written a formula which someone sent me and want to
know how they made the formula
This is what they wrote:
http://stockcharts.com/def/servlet/SC.web?c= SIZ
,uu[l,a]daclyyay[pb50!b20][vc60][iLe12,26,9!Ll14]&pref=G


Please help
Regards
Zarir







"mango7" wrote:


how do i get excel to automatically add my formula to new rows in a
certain column. Excel 2002


--
mango7
------------------------------------------------------------------------
mango7's Profile:
http://www.excelforum.com/member.php...o&userid=29529
View this thread:
http://www.excelforum.com/showthread...hreadid=492306





David McRitchie

formulas and new rows
 
You can try using
Tools, Options, Edit, Extent List Formats and Formulas

But you might want to take a look at my page
Insert a Row using a Macro to maintain formulas
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

particularly the main topic for insertion of a specified number of
rows and also look at
Change Event (#change_event)
which will fill in the formulas from the row above when entering a constant (text or number) into Column A provided the remainder of
the row is empty.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"mango7" <mango7.....
how do i get excel to automatically add my formula to new rows in a
certain column. Excel 2002




zarir kalian

formulas and new rows
 
Thanks Don
It worked, made my day!!

"Don Guillett" wrote:

Te first part is the url and the bracketed parts are variables to the
standard url.

Go here
http://stockcharts.com/def/servlet/SC.web?c=ibm
click on update chart and you get
http://stockcharts.com/def/servlet/SC.web?c=IBM,uu[m,a]daclyyay[pb50!b200][vc60][iUb14!La12,26,9]&pref=G
--
Don Guillett
SalesAid Software

"zarir kalian" <zarir
wrote in message
...
Hi:
I just joined and did not know how to send a new message can someone show
me.
I have a question on written a formula which someone sent me and want to
know how they made the formula
This is what they wrote:
http://stockcharts.com/def/servlet/SC.web?c= SIZ
,uu[l,a]daclyyay[pb50!b20][vc60][iLe12,26,9!Ll14]&pref=G


Please help
Regards
Zarir







"mango7" wrote:


how do i get excel to automatically add my formula to new rows in a
certain column. Excel 2002


--
mango7
------------------------------------------------------------------------
mango7's Profile:
http://www.excelforum.com/member.php...o&userid=29529
View this thread:
http://www.excelforum.com/showthread...hreadid=492306






Don Guillett

formulas and new rows
 
Glad it helped

--
Don Guillett
SalesAid Software

"zarir kalian" wrote in message
...
Thanks Don
It worked, made my day!!

"Don Guillett" wrote:

Te first part is the url and the bracketed parts are variables to the
standard url.

Go here
http://stockcharts.com/def/servlet/SC.web?c=ibm
click on update chart and you get
http://stockcharts.com/def/servlet/SC.web?c=IBM,uu[m,a]daclyyay[pb50!b200][vc60][iUb14!La12,26,9]&pref=G
--
Don Guillett
SalesAid Software

"zarir kalian" <zarir
wrote in message
...
Hi:
I just joined and did not know how to send a new message can someone
show
me.
I have a question on written a formula which someone sent me and want
to
know how they made the formula
This is what they wrote:
http://stockcharts.com/def/servlet/SC.web?c= SIZ
,uu[l,a]daclyyay[pb50!b20][vc60][iLe12,26,9!Ll14]&pref=G


Please help
Regards
Zarir







"mango7" wrote:


how do i get excel to automatically add my formula to new rows in a
certain column. Excel 2002


--
mango7
------------------------------------------------------------------------
mango7's Profile:
http://www.excelforum.com/member.php...o&userid=29529
View this thread:
http://www.excelforum.com/showthread...hreadid=492306








mango7

formulas and new rows
 

thanks
Your website is great


--
mango7
------------------------------------------------------------------------
mango7's Profile: http://www.excelforum.com/member.php...o&userid=29529
View this thread: http://www.excelforum.com/showthread...hreadid=492306



All times are GMT +1. The time now is 01:11 AM.

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