Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to pick data
hello
in column A i have dates in column B i have stock name in column C i have NASDAQ index values data starts from cell A2, B2 , C2 resp. the length of data can vary as i can change the stock name or i can change the index say SP500 index or so... now i want to write a macro that will check the values in column C and if it is negative, it will copy that date , stock price and the index value and paste all this in column F, G and H. so i want this macro to identify all the dates, stock prices and index values on the condition that the index was negative. so if index was -ve say 11 times in the last 30 days , i want in column F , G , H .....to be able to see corr dates , stock prices and index values using this macro ... can any1 plssssssss help...... thanks sam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to pick a specific cell within a macro .... ?? | Excel Discussion (Misc queries) | |||
macro pick 100 lines | Excel Discussion (Misc queries) | |||
pick up last occupied cell to the left macro | New Users to Excel | |||
Start Macro after user selects a choice from a pick list | Excel Discussion (Misc queries) | |||
macro to browse for workbook, pick up data and looping | Excel Worksheet Functions |