Previous Topic Next Topic

Excel lists - extracting data from it.

Closed
jipiedra - 13 Feb 2009 à 07:53
 Helper - 17 Feb 2009 à 19:24
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 responses

Réponse 1 / 2
Helper
13 Feb 2009 à 15:11
Is your new list on the same worksheet or a new worksheet?
jipiedra
13 Feb 2009 à 15:18
i need to do both (on the same worksheet and on a new one as well)
Helper > jipiedra
13 Feb 2009 à 18:09
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
Réponse 2 / 2
jipiedra
17 Feb 2009 à 07:00
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.
Helper
17 Feb 2009 à 19:24
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]

Similar discussions

How to extract data from one excel file to another
zamorin -
zamorin -

2 responses
Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses
Extract data from one sheet to another
phanikr -
Mazzaropi -

1 response
How do I extract specific data from a cell in excel?
mcat79 -
ac3mark -

5 responses
Hosted app data will not clear
Woody_3336 -
woody_3336 -

7 responses