Add while deleting rows? Is this possible via VBA Macro
Hello,
I have the attached workbook which in column 'p' has a number. At the end of each number there is a -xx where the xx represents a two digit number. I am only interested in the rows with -11 in however this is where is gets tricky. I would like the amount and hours that appear in column X and Y respectively to be added to the amount and hours for the -11 row; so for example if I had:
I would like to delete FR-3418432-12 and FR-3418432-13 but before deleting add the hours and amount for these two rows to FR-3418432-11 so after it would say:
Number Amount Hours
FR-3418432-11 $30 150
The attached spreadsheet provides an example with the way in which the data tends to appear. I would be grateful for anyone's input to this as always.
What i mean -12 and -13 and then -11 or it will be always -11 ,-12 and -13??
Saurabh...