Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am writing a macro to automate several processes. I have the following
table where column A has positive and negative values and column B is blank. I need a formula that will find all the negative values in column A and move them to column B. In essence, it needs to say if number in column A < 0, then cut it and paste it into column B. A B 1. Original Negative 2. 3.72545 3. 3.4584 4. 3.1071 5. -0.460399 6. -0.803222 7. -1.12457 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA Code - Find & Move | Excel Discussion (Misc queries) | |||
Find text and move | Excel Discussion (Misc queries) | |||
find text and move it | Excel Discussion (Misc queries) | |||
Find and Move Data | Excel Discussion (Misc queries) | |||
Macro - Find a value and then move down | Excel Discussion (Misc queries) |