VBA Excel partial cell compare to another cell

I

irishcab

Joined
Oct 10, 2011
Messages
2
Reaction score
0
I am trying to compare a part of a cell with another whole cell. The parts of the cells I need are always between parens. I need to do this to multiple cells in a column and compare with another cell. More detail...
Cell D6 and D7 contain "Trigger (1234)..." and "Trigger (300)" respectively. The 1234 needs to be compared to J4 and if same the I need to perform addition on a seperate set of cells, if different then I perform subtration on a seperate set of cells. The 300 then needs to be compared to J5 and if same the I need to perform addition on a seperate set of cells, if different then I perform subtration on a seperate set of cells.
Some times I'll have two rows of "Trigger..." and sometimes only one. Basically my Trigger row and the compare row should be a 1:1 ratio.
The Trigger data will always be in column D and the compare cell will always be above and in column J.

Data will always look like one of the following two examples...

Row1 Compare
Row2 Compare
Row3 Trigger
Row4 Trigger

OR

Row1 Compare
Row2 Trigger

Thanks for all your help!!
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Compare part of cell to another cell and then calculate 0
Compare two cells, if equal move a third cell to another cell 3
Excel VBA 1
excel spreadsheet compare 3
Excel 2013 Merge Data 2
Compare multiple cells and highlight differences 5
check first 3 characters of a cell and compare to a table 4
Event Trigger - EXCEL VBA 3

Top