Automate Task In Excel
July 13th, 2009
I’m trying to automate a task in Excel, I’ve attached two images. The first image is an example of the original Excel file, the second image is how I want the script to edit the file.
As you can see in the images, I want it to compare column B and E, for each equal number, move the cells in column E/F to the same row where the numbers in B and E is equal.
If the numbers in column E does not exist in column B, move them to the bottom of the sheet.
I use Microsoft Excel 2007.
Categories: Programming, Visual Basic automate, automate task, column, Excel, excel programming visual, programming visual basic, task
