Excel lists - extracting data from it.

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

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,

jipiedra

2 replies

Is your new list on the same worksheet or a new worksheet?
0
i need to do both (on the same worksheet and on a new one as well)
0
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.

http://www.4shared.com/file/87561168/79cae1bb/Example_ExcelList.html
0
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.
0
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.


[URL=http://www.4shared.com/file/88207953/8a40d065/Example_ExcelList.html]Example_ExcelList.xls[/URL]
0