Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Confirming existence of dependents
I have a long list of 'single point' numerical data items that a colleague
has extracted from a large written document. This data has been put into rows; with column A containiung the data label/description, and column B containing the actual data item (be it a general number, a date, a currency amount, etc., etc..). I have used many of these elsewhere within the workbook, but not all of them so some of the data is effectively redundant. Is there an easy way of returning a "Yes" or "No" into column C, confirming that the data point has been used elsewhere in the model (i.e. has dependents)? A macro button in the top left of the worksheet that when run does the tests and then pastes either a "Yes" or "No" into column C, as appropriate, for each row seems to be required, but I do not know what this would like. Any help on how to write this would be very much appreciated. Thanks Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
co existence | Excel Discussion (Misc queries) | |||
Check for existence | Excel Discussion (Misc queries) | |||
Confirming Vlues in 2 Cells Appear in a List | Excel Worksheet Functions | |||
how to change data in worksheet in text without confirming each s. | Excel Discussion (Misc queries) | |||
Confirming existence of dependents | Excel Programming |