ENTER DATA SHOULD NOT DELETE

[sa.1985]

Dear Sir,


if i write below formula in cell b1, when i delete entry of a1 then b1 should not be delete


=IF(a1="","",a1)

 

[sa.1985]

have u any answer for above matter ? please

 

[dan_l]

It shouldn't: are you deleting the contents of cell a1 or are you actually deleting the cell a1?

 

[Luke M]

You can't do that. Rather than using a formula, you should either manually copy A1 to B1, or use a macro.


BTW, your formula could simply be:

=A1

 

[sa.1985]

OK

 

[sa.1985]

CAN YOU HELP ME WITH MACRO CODDING ?

 

[Luke M]

Right click on sheet tab, view code, paste this in:

[pre]

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub
Application.EnableEvents = False
If Range("A1") <> "" Then
Range("B1") = Range("A1").Value
End If
Application.EnableEvents = True
End Sub

[/pre]
This will make B1 = A1 whenever you make a change to A1 (other than clearing the cell).

 

[prasaddn]

Nice little trick Luke

 

[Luke M]

Thanks, prasaddn. =)

 

[sa.1985]

Dear Sir,


You have given me macro code for data should not delete after entry

I have a data entry form and i want to its details in different 5 sheets


Please find the link i write my question's in this sheet


https://docs.google.com/open?id=0B6VY6rBw3NuBcEhUSWtiS3RJZWc

 

[sa.1985]

Dear all,


Can u help me in above question ?

 

[sa.1985]

Dear All,


Anybody can help me ?

 

[SirJB7]

Hi, sa.1985!


What you're asking for it's easier to achieve with an user form, or at least adding a command button to your data entry worksheet so as to indicate Excel when to send (i.e. after finish entering, and modifying, and accepting) data to the 5 other sheets.

Bot scenarios seem to be a little far beyond what you can handle, so maintenance might not be simple for you.


I humble suggest you to investigate a little more on userforms, because there you'll have to use a command button too to perform data distribution among target sheets. Whoever provides you the code or update your uploaded workbook will be giving you fish and not aiding you to learn fishing.


It's up to you to choose the right path. Besides, have you searched within this website to see if there are not similar topics solved? If I don't remember wrong, there are many.


Regards!