Parse a Workbook-Newbie
 

Hi!
I've got a huge excel file with inventory items in one column, and
quantities in the next column. I need to be able to do two things:
1) Be able to find a specific word in the inventory column and put that out
somewhere else...along with the quantities
2) Be able to simply parse out any inventory with 0 in the quantity column.

I'm not new to excel but am definitely new to any formulas. is there an
add-in of some sort that can help with this??
Thanks!

Hey.

Do you have any experience with Visual Basic? It should be pretty easy to
create a macro and write a short VB script to do the job.

Something like:

dim temp, n

Do 'Counts the number of items you have
n = n + 1
Loop Until IsEmpty(ThisWorkbook.Sheets("Inventory").Cells(n, 1))

For k=1 to n
If (Sheets("Inventory").Cells(k, 2)0) 'If invenotry 0
'Copy item
Sheets("Wherever").Cells(temp,1) = Sheets("Inventory").Cells(k, 1)
'Copy Quantity
Sheets("Wherever").Cells(temp,2) = Sheets("Inventory").Cells(k, 2)
temp= temp+1
end if

next

Something like this... and then do whatever you want when invenory =0...

Hope this helps!

-Michael

"basin" wrote:

Hi!
I've got a huge excel file with inventory items in one column, and
quantities in the next column. I need to be able to do two things:
1) Be able to find a specific word in the inventory column and put that out
somewhere else...along with the quantities
2) Be able to simply parse out any inventory with 0 in the quantity column.

I'm not new to excel but am definitely new to any formulas. is there an
add-in of some sort that can help with this??
Thanks!