Please help me write a macro to find text, copy values on same row, paste them in another row and delete the original row
Although I'm not a complete newbie to excel, I'm fairly new to VBA scripting.
I'm running Excel 2007 and I'm trying to acomplish this: (please see example below)
I need to write a macro that finds the substring "MLEA" in a row and add all values to the one that has the "MPRE" substring, then delete de "MLEA" row.
Please note that names are almost identical but for the MLEA, MPRE which defines the time spent on each function for this employee.
I dont really know if all this can be done through scripting, any help will be greatly appreciated.]
Thanks in advance
use this to add calculated
use this to add calculated columns to your data:
http://excelexperts.com/xla-routines-eeaddcalculatedcolumn
You'll want 2 boolean calculated columns:
1. Does Col 1 contain "MLEA"
2. Does Col 2 contain "MPRE"
Now you need to add the TRUE from "MLEA" to "MPRE"
To do this, move the "MLEA" data to another sheet using this:
http://excelexperts.com/xla-routines-eefilterandmove
now, you can copy and paste special (Add) to the "MPRE" data, and clear the calculated columns