pdx_2188
03-02-2011, 01:14 PM
I am a Business Analyst for a company, and i run Point of Sale reports monthly. one of the companies that I deal with sends reports that are very difficult to work with EX:
CAP010 CAPGEMINI ENERGY (Customer)
1974028025 (Part Number) 2010 (year) 2 (Month) 2 (QTY)
INTERMEC 1-974028-025 LINE CORD (Description)
292892B21 2010 2 1
HP 292892-B21 DUAL CORE PROCESSOR KIT
300682B21 2010 2 2
HP 300682-B21 4GB PC2100 SDRAM
They Put their Customers name at the top, and move the description of the part number underneath the part number. In order to decipher what I need the format has to be clean. So it has forced me to create a macro that still takes some time that just records the action of moving the description to the right of the quantity, and then I use a find blank cells in the month column and delete rows.
My question is would it be possible to create something that says if Month column is not blank then move one row down and column A to one row up and column E?
I hope this is not overly complicated/confusing.
CAP010 CAPGEMINI ENERGY (Customer)
1974028025 (Part Number) 2010 (year) 2 (Month) 2 (QTY)
INTERMEC 1-974028-025 LINE CORD (Description)
292892B21 2010 2 1
HP 292892-B21 DUAL CORE PROCESSOR KIT
300682B21 2010 2 2
HP 300682-B21 4GB PC2100 SDRAM
They Put their Customers name at the top, and move the description of the part number underneath the part number. In order to decipher what I need the format has to be clean. So it has forced me to create a macro that still takes some time that just records the action of moving the description to the right of the quantity, and then I use a find blank cells in the month column and delete rows.
My question is would it be possible to create something that says if Month column is not blank then move one row down and column A to one row up and column E?
I hope this is not overly complicated/confusing.