dear all,
i have a spreadsheet that has >30000 rows. the sheet shows 'sale' and 'amount'. in the attached sheet i would like cell B6 to become a negative number as it is a returned item.
pl provide a macro where for entry 'IP sale return' the corresponding entry in col B becomes a negative number. pl ensure that in this formula or macro i can change the column and row number, as necessary, to get similar result - this is because there are several types of entry for diff. returned items.
thanks.
Try this code to see if this works as per your requirement.
Please Login or Register to view this content.
Last edited by sktneer; 06-16-2014 at 03:50 PM.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Hi,
Here you go.
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Another one
Please Login or Register to view this content.
If you run the other guys macros twice it will change the negative back to positive. They need some Abs() function in their code to keep this from happening.
Can easily cater for that
Please Login or Register to view this content.
MarvinP,
If a cell has a lower case(return,not RETURN), your code will not pick that row
Last edited by AB33; 06-16-2014 at 04:20 PM.
I think that I have taken care of this point in the code. Have you checked it?Originally Posted by MarvinP
thanks.
in my xls, 'sale' is 'col Q' and amount is 'col AU'. how do i change the macro so that this is accounted for? sorry, my grasp of xls macros is very basic.
Please Login or Register to view this content.
If I change my code as per your new requirement, it would be like this.......
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks