Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello All,
I have an excel spreadsheet with 10 columns. One of the columns is called "Add Usage" and in that column I have blank cells but I also have cells that reads "Add 2008 usage." I would like to create a formula or macro that will loop or go through the list and then populate the data for that Row at the bottom of the sheet whenever it finds the word "Add 2008 Usage" in the Add usage column. Basically the results would be all the information from column A - J based on the "Add Usage" criteria. Is that possible? I tried an IF statement but quickly failed. Would a macro do it? Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sub Macro vrs Function Macro Auto Start | Excel Discussion (Misc queries) | |||
macro or function? | Excel Discussion (Misc queries) | |||
Function or macro? | Excel Worksheet Functions | |||
Macro or function | Excel Worksheet Functions | |||
macro or function | Excel Worksheet Functions |