excel help

vvn

New Member
#1
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
 
#2
vvn said:
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
 
#3
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
 
#4
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
 
#5
Crusaderv said:
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..........
 
#6
Follow this step to automatically change value in D1 whenever you change value in A1:

1. In Cell D1, enter the formula =A1

That is all. Whenever you change A1, D1 value also changes to the same value.
 
#7
I think u didnt follow my reply.

u want whatever amount u enter in A1 to appear in D1. Right? Now go to Cell D1. Enter this formula in that cell =A1

Thats all. Whatever u enter in A1 will appear automatically in D1. If u change value in A1, D1 also will change to the same value.

To be more specific, if u enter 5000 in A1, the same 5000 will appear in D1. If u change 5000 to 10000, D1 value also will change from 5000 to 10000.

Every time u change value in A1, D1 also changes to the same value.

I hope I am clear now.
 

Similar threads