Excel lists - extracting data from it.

jipiedra - Feb 13, 2009 at 07:53 AM
 Helper - Feb 17, 2009 at 07:24 PM

I hope someone can help me! I have a long list of items in one column. next to each item I have to give certain values to some of them. The question is: how can I make a new list with only the items that have values assigned.

Thank you,


2 replies

Is your new list on the same worksheet or a new worksheet?
i need to do both (on the same worksheet and on a new one as well)
Helper > jipiedra
Feb 13, 2009 at 06:09 PM
Here is an example file. See if it works for you. I highlighted the cells where the data will appear in sheet 1 and sheet 2. Click the "Copy Values" button to run the macro. I also created a "Clear" button to clear the data if you want to run it a couple of times. The logic is, if there is a value in column B, then it will copy the values from columns A and B to the destination ranges. Hope this helps.

Hi, thanks for the example file. I see how it works. I have 2 comments. the clear button works only for a specific amount of items.
then, is it possile to do this without macros?

Thanks again.
The clear button was just coded to remove the contents for the example on the sheet, but it can be changed to any range of cells. Also, I added excel formulas in columns N and O to give you an idea of what you could use instead of a macro.