Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Excel macro?
I have a spreadsheet which lists clients' names in Column A. When I add a
new on at the bottom, I need to quickly check that the name is not an existing customer i.e. already on the list above. I have tried to record a macro which copies the selected cell, and then tries to find any other entries with the same name on the sheet (using the Find... function on the edit menu) but the macro only seems to record the 'copy' command and nothing after that. Does anyone know how to get round this please? TIA V |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Excel macro?
Well, what I would do is use conditional formatting.
Select the entire column A. Then go to the menu <Format<Conditional Formatting Change the dropdown from "Cell Value Is" to "Formula Is Enter "=COUNTIF($A:$A,A1)1" without the quotes change the format to highlight Red <OK Now, if you enter a duplicate name the cell will turn red. Tom |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Excel macro?
"TomPl" wrote in message
... Well, what I would do is use conditional formatting. Select the entire column A. Then go to the menu <Format<Conditional Formatting Change the dropdown from "Cell Value Is" to "Formula Is Enter "=COUNTIF($A:$A,A1)1" without the quotes change the format to highlight Red <OK Now, if you enter a duplicate name the cell will turn red. Tom Tom Good idea - many thanks! V |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) |