Inserting 0 in selected cells in excel

Byrner

New Member
Joined
May 17, 2018
Messages
18
Hello , A very warm Hello or Hi to everybody from Ireland

I have just joined my name is Maureen, Not great on computers but using excel for a small craft business I am trying to get going.
Can anybody help? I need to insert the number 0 in selected cells , is there a quicker way to do this other then by typing in 0 opposite every selected name?
I have a long list of customer names, if one name on the list e has order from me in the past I need to insert 0 in the column beside their name.
Its an old list, so I have to read from the list and and when a name matches insert the 0
Any help would be really great
Thanks again
Maureen
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
It might help to provide some sample data in the format (layout) as you have it. You can also use places like dropbox to upload a sample copy of your file there and then link it here, some people can look at those links to help as well.

I think you might be able to use vlookup or maybe and index/match formula, but without seeing the data and layout it is hard to speculate.
 
Upvote 0
Hi Thank you for the reply, I cannot really post real Names on my list but this is a sample of what it looks like

They are all single columns and if the name matches my list I insert a (0) in the cell beside the name.
Thanks again
M.
DateFirst NameSurname AddressTel1Tel 2 Yes
21/03/2017abcxyzzyz1231230
22/03/2017abcxyzzyz123123
23/03/2017abcxyzzyz123123
24/03/2017abcxyzzyz1231230
25/03/2017abcxyzzyz123123
26/03/2017abcxyzzyz123123
27/03/2017abcxyzzyz123123
28/03/2017abcxyzzyz123123
29/03/2017abcxyzzyz123123
30/03/2017abcxyzzyz123123
31/03/2017abcxyzzyz1231230

<colgroup><col><col><col span="3"><col><col></colgroup><tbody>
</tbody>
 
Upvote 0
hnks for the reply, Cannot really show real names etc, but this is an example of what i am doing.Hope it helps
Maureen


DateFirst NameSurname AddressTel1Tel 2 Yes
21/03/2017abcxyzzyz1231230
22/03/2017abcxyzzyz123123
23/03/2017abcxyzzyz123123
24/03/2017abcxyzzyz1231230
25/03/2017abcxyzzyz123123
26/03/2017abcxyzzyz123123
27/03/2017abcxyzzyz123123
28/03/2017abcxyzzyz123123
29/03/2017abcxyzzyz123123
30/03/2017abcxyzzyz123123
31/03/2017abcxyzzyz1231230



<colgroup><col width="75" style="width: 56pt;"><col width="97" style="width: 73pt;"><col width="64" span="3" style="width: 48pt;"><col width="78" style="width: 59pt;"><col width="64" style="width: 48pt;"></colgroup><tbody>
</tbody>
 
Upvote 0
Hi again
Is it possible to double click/ right click on the cell and automatically insert 0, I found it online but only works with x cannot seem to change the x to 0
Thanks
 
Upvote 0
All of your sample data are the same values, so not sure why you have a zero in some areas and not in others. Can you change the sample data to be unique, but to kind of mirror your real data so we can help better.

Does your data ever duplicates of names?
 
Upvote 0
Try this:-
Code:
Private [COLOR=navy]Sub[/COLOR] Worksheet_SelectionChange(ByVal Target [COLOR=navy]As[/COLOR] Range)
    [COLOR=navy]If[/COLOR] Target.Column = 7 And Not Target.Row = 1 [COLOR=navy]Then[/COLOR]
        Target = IIf(Target = "", 0, "")
    [COLOR=navy]End[/COLOR] If
[COLOR=navy]End[/COLOR] [COLOR=navy]Sub[/COLOR]


To insert code:-
In data sheet Right click sheet "Tab", select "View Code", Vbwindow appears, Paste code in VbWindow, close Vbwindow

To run code click any cell in column "G"
Click once for a "0" click again to clear cell
Regards Mick
 
Last edited:
Upvote 0
Hi the
The (0) is to indicate that the name appears on my written list. The written list is thousands of names that span the last 20 years.
I am trying to match the old list with what I have on file. Some of the names on five go back about 5 years.,
The reason I use a zero number is because its a program I borrowed and works really well but needs the number (0) to trigger it
So as of now I am typing in the 0, but trying to find a quicker way. The names do not duplicate very much either as the sales are mostly to overseas visitors who purchased items while on holiday here.
But Thanks again for your help
Maureen
 
Upvote 0
A variation on MickG's code. This works on double click
Code:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
   If Target.Column <> 7 Then Exit Sub
   Cancel = True
   Target.Value = IIf(Target.Value = "", 0, "")
End Sub
 
Upvote 0
OK, I can't think of a way to make excel, or any computer program for that matter, enter in a value based on a paper list. Maybe I am missing what you are trying to accomplish, and if so I apologize for that, but how would you like Excel to know to put in a zero from something outside the program?
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,240
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top