| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Put numbers in column B cells when Value Change in Column A cells
Hi all, I have data in column A (see below)
ROW A---------Column 1 Heading 2 BTC 3 BTC 4 BTC 5 GIS 6 GIS 7 VXZ 8 VXZ 9 BTC 10 BTC I want macro on button which should produce result in column B something like (see below) ROW A B---------Columns 1 Heading Heading 2 BTC 1 3 BTC 1 4 BTC 1 5 GIS 2 6 GIS 2 7 VXZ 3 8 VXZ 3 9 BTC 4 10 BTC 4 In other words I want macro to check in column A cells and put numbers in column B cells and when where value become different in column A cells then it should also change the value in column B cells. Please can any friend can help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To get an average of a column of numbers not zero/blank cells | Excel Worksheet Functions | |||
| Display cells(text) in one column based on cells which are present inother column | Excel Discussion (Misc queries) | |||
| Copying a column of single cells into a column of merged cells | Excel Discussion (Misc queries) | |||
| How can I change column numbers back to column letters? | Excel Worksheet Functions | |||
| How do I identify cells with matching numbers within a column. | Excel Worksheet Functions | |||
![K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
