excel help

Discuss excel help at the Introductions within the Traderji.com - Discussion forum for Stocks Commodities & Forex; Sir, I am a new member and first of all I hello's every Senior member,s. ...


Go Back   Traderji.com - Discussion forum for Stocks Commodities & Forex > TRADING & INVESTING > Introductions

Notices

Introductions New to Traderji.com? You can start off by introducing yourself here! Existing members please welcome new members here.


Reply
 
Thread Tools
Sponsored Links
  #1  
Old 6th August 2005, 08:36 AM
vvn vvn is offline
Member
 
Join Date: Aug 2005
Posts: 2
Appreciation: 20
vvn is on a distinguished road
Angry excel help

Sir,
I am a new member and first of all I hello's every Senior member,s.

My problem in Excel work sheet is as follow:

If any data is entered in Cell A1 (Say 5000)of a work sheet it should be automatically paste to cell D1 as 5000 and again if any data I entered in Same cell(A1) by overwriting previous data (5000) by 10000 it should be automatically paste to D2 as 10000 as so on......

Please help me is there aany way to do so.

VVN
Reply With Quote
  #2  
Old 6th August 2005, 11:00 PM
Member
 
Join Date: Jun 2005
Posts: 29
Appreciation: 20
nirmald is on a distinguished road
Default Re: excel help

Quote:
Originally Posted by vvn
Sir,
I am a new member and first of all I hello's every Senior member,s.

My problem in Excel work sheet is as follow:

If any data is entered in Cell A1 (Say 5000)of a work sheet it should be automatically paste to cell D1 as 5000 and again if any data I entered in Same cell(A1) by overwriting previous data (5000) by 10000 it should be automatically paste to D2 as 10000 as so on......

Please help me is there aany way to do so.

VVN

Hi VVN,

Welcome to Tradreji. I don't think that is possible, but again lets hear from others.

Rgds
Reply With Quote
  #3  
Old 6th August 2005, 11:34 PM
Member
 
Join Date: Aug 2005
Posts: 2
Appreciation: 20
khvaripa is on a distinguished road
Default Re: excel help

While copying in D1 cell u hv to put the "=" sign & then key the number so that the next time u change the number in A1 cell it will automatically change in D1 cell
khvaripa
Reply With Quote
  #4  
Old 7th August 2005, 05:34 AM
Member
 
Join Date: Aug 2005
Posts: 3
Appreciation: 20
Crusaderv is on a distinguished road
Default Re: excel help

Not sure if this is what you want.
1.key in 5000 in A1
2. Go to D1 and key in the formula =A1
3. If you want the value in A1 in D2,D3 etc. Change the above to =$A$1
4. Try changing A1 to 10000 to see the effect in D1
Reply With Quote
  #5  
Old 8th August 2005, 08:06 PM
Member
 
Join Date: Aug 2005
Location: Delhi
Posts: 117
Appreciation: 23
amitkr is on a distinguished road
Default Re: excel help

Quote:
Originally Posted by Crusaderv
Not sure if this is what you want.
1.key in 5000 in A1
2. Go to D1 and key in the formula =A1
3. If you want the value in A1 in D2,D3 etc. Change the above to =$A$1
4. Try changing A1 to 10000 to see the effect in D1

Works..........
Reply With Quote
Sponsored Links


Reply

Bookmarks


Advertise Here


« Novice | intro »
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads for: excel help
Thread Thread Starter Forum Replies Last Post
Need BSE Stock Price List in Electronic form (Excel, CSV format) gharesh End of Day 5 20th June 2008 07:55 PM
FREE Stock Charts with Excel TATrader Technical Analysis 4 16th June 2008 11:16 AM
excel to metastock veneet Software 3 21st February 2008 02:29 PM
covert data from excel spreadsheet to metstock format veneet Data Feeds 10 30th November 2005 01:25 PM


All times are GMT +5.5. The time now is 10:20 AM.

Indemnity, Disclaimer & Disclosure Notice:
• By visiting Traderji.com you indicate your acceptance of our Forum Rules Disclaimer & Disclosure and indemnify Traderji.com, its associates and related parties of all claims howsoever resulting from the usage of the forum.
Disclaimer: Trading or investing in stocks & commodities is a high risk activity. Any action you choose to take in the markets is totally your own responsibility. Traderji.com will not be liable for any, direct or indirect, consequential or incidental damages or loss arising out of the use of this information.
Disclosure: The information in this forum is neither an offer to sell nor solicitation to buy any of the securities mentioned herein. The writers may or may not be trading in the securities mentioned.
• All names or products mentioned are trademarks or registered trademarks of their respective owners.
General Content Disclaimer Notice:
In light of our policy of encouraging candid, open exchanges of views and the rapid distribution of information originating from many sources, Traderji.com cannot determine the accuracy of information that may be uploaded to the forum. Opinions, advice and all other information expressed by participants in discussions are those of the author. You rely on such information at your own risk. You are urged to seek professional advice for specific, individual situations and not rely solely on advice or opinions given in the discussions. Since Traderji.com is an open and free discussion forum, any comments made by members of this forum in their posts reflect their own views and not of the owner or administrator of Traderji.com. Thus the owner/administrator indemnify themselves of all claims whatsoever and will not be liable or responsible for any members comments/views in this forum Traderji.com. If you find any objectionable or offensive posts made by members of this forum which you would like to bring to our notice for removal then please Contact Us.
 


Copyright © 2001 - 2008, Traderji.com All Rights Reserved.

Recommended Websites - www.TradersEdgeIndia.com - www.TradingPicks.com - www.MasterOfTrading.com