Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Formula or Macro
Hello All,
I have an excel spreadsheet with 10 columns. One of the columns is called "Add Usage" and in the 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 through the list and then populate only the data at the bottom of the sheet whenever it finds the word "Add 2008 Usage" in the Add usage column. Is that possible? I tried an IF statement but quickly failed. Would a macro do it? Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Formula or Macro
hi
have you tried the =SUMIF formula. that might work. regards FSt1 "Marilyn" wrote: Hello All, I have an excel spreadsheet with 10 columns. One of the columns is called "Add Usage" and in the 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 through the list and then populate only the data at the bottom of the sheet whenever it finds the word "Add 2008 Usage" in the Add usage column. Is that possible? I tried an IF statement but quickly failed. Would a macro do it? Thanks, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Formula or Macro
hi
see your post under worksheet functions. Regards FSt1 "Marilyn" wrote: Hello All, I have an excel spreadsheet with 10 columns. One of the columns is called "Add Usage" and in the 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 through the list and then populate only the data at the bottom of the sheet whenever it finds the word "Add 2008 Usage" in the Add usage column. Is that possible? I tried an IF statement but quickly failed. Would a macro do it? Thanks, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Formula or Macro
I dont want to Sum the data. I want Excel to give me the data contain across
the 10 columns. Instead of me writing out all of the information for any row that has "Add usage 2008" it should populate it for me based on the fact that, that particular cells rads "Add usage 2008" "FSt1" wrote: hi see your post under worksheet functions. Regards FSt1 "Marilyn" wrote: Hello All, I have an excel spreadsheet with 10 columns. One of the columns is called "Add Usage" and in the 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 through the list and then populate only the data at the bottom of the sheet whenever it finds the word "Add 2008 Usage" in the Add usage column. Is that possible? I tried an IF statement but quickly failed. Would a macro do it? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro or Formula Question | Excel Worksheet Functions | |||
Excel formula / Macro ? | Excel Discussion (Misc queries) | |||
Excel formula - should this be a macro? | Excel Worksheet Functions | |||
run a macro in excel formula | Excel Programming | |||
Excel formula in macro | Excel Programming |