ssinghal
04-10-2008, 09:23 PM
I have a spreadsheet with raw data for which I would like to reformat so that I can use autofilter to see data in usable form. Here is what I need to do:
I have an empty column A. I need to search each row for the text "Total" in column B. Once found, the NEXT row column B should be copied to column A in that same row. I want that same text to be copied to column A until the next "Total" comes up. Then that total will have same copy as others above it but the next row will start a new copy of the text in row B.
Basically, the Property Names are entered as titles but I need it to be in a cell for each row of data so that i can use autofilter.
I appreciate any help. Thanks.
Sanjeev
I have an empty column A. I need to search each row for the text "Total" in column B. Once found, the NEXT row column B should be copied to column A in that same row. I want that same text to be copied to column A until the next "Total" comes up. Then that total will have same copy as others above it but the next row will start a new copy of the text in row B.
Basically, the Property Names are entered as titles but I need it to be in a cell for each row of data so that i can use autofilter.
I appreciate any help. Thanks.
Sanjeev