View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
myshak myshak is offline
external usenet poster
 
Posts: 11
Default Delete colomns and rows

i have a file

Item Feb 1 - 4, 07
Qty Amount % of Dep Avg Cost COGS Avg COGS

A 21.00 1,186.86 3.55% 56.52 315.00 15.00
A-4845 8.00 205.92 0.62% 25.74 0.00 0.00



File It has two main col Item and DATES. Under Dates col. it has qty
amount price etc. It also has emtply col.

I need to keep Item Col. I need to keep only QTY AND Amount under
Dates col. I need to delete all other columns. Keep in mind there
are several main col with DATES. Under these col i only need to keep
QTY and AMOUNT COL.

I am looking for macro for that. Any advice would be highly appreciated