LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 211
Default Is there a Function or Macro for This?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sub Macro vrs Function Macro Auto Start Pat Excel Discussion (Misc queries) 7 June 6th 07 09:53 PM
macro or function? CMD Excel Discussion (Misc queries) 0 October 4th 06 02:00 PM
Function or macro? Rob N Excel Worksheet Functions 0 August 12th 06 08:14 PM
Macro or function MIchel Khennafi Excel Worksheet Functions 2 May 15th 06 09:16 PM
macro or function BAZZA Excel Worksheet Functions 2 September 18th 05 02:44 PM


All times are GMT +1. The time now is 11:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"