Hello I need your help again
I have been strugling with this problem for really long and now I hope someone will help me.
I have really long sheet populated with various data (one or more are populated with numbers) and I have to find two opposite data and delete/cut them to another sheet. So I would like to make macro that do this
- find two numbers in one column that sum of those two are 0 (lets say it is column B and I have to find two numbers which sum is 0 (a+b=0; 50+(-50) = 0)
- then I have to check if those two numbers have same data in another column (column A)
- if this is OK (sum is 0, and data in column A is same) then I have to delete/cut those two rows and past them in another sheet (in same workbook)
It would be great, if macro could let user to chose in which column are first numbers (which I sum them) and in which column is second data.
I hope I wrote my problem with enough details and I hope there is solution for my problem
Thanks for any help!
Bookmarks