Link to home
Start Free TrialLog in
Avatar of gisvpn
gisvpnFlag for United States of America

asked on

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:

Number                  Amount Hours
FR-3418432-11        $10         50
FR-3418432-12        $10         50
FR-3418432-13        $10         50

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.

Regards,

GISVPN
Example-WS--3.xlsx
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Quick question will be the one which has -11 entry will always be the first before rest or it can be later as well??

What i mean -12 and -13 and then -11 or it will be always -11 ,-12 and -13??

Saurabh...
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.