| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a "key"
Hi, i'm trying to write a macro that will search the sheet i am workin in and if the letters PY appear in a cell anywhere in the sheet th macro will return "PY = Prior Year" in column A, in a row beneath th last row being used. This i can do. However, i having searched for "PY" i then want the macro to search fo "BS" returning a value to the A column, beneath the lowest active row. Ideally i want to be able to repeat this for a variety of informatio searches, producing a key. I'm sure this is possible but my inability to do it is driving me mad please help me!! ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| How to create a scatter chart with 2 "X" values with common "Y"s | Charts and Charting in Excel | |||
| cannot use "Create List" and "Share Workbook" same time | Excel Discussion (Misc queries) | |||
| create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
![concatenator[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
