Hi
Hopefully somebody can guide me in the right direction..
I have a table with 2 columns:
Column A always contains text
Column B always contains numbers
The table does not have a fixed amount of rows and will be continually increasing over time
I want a macro that will search the table from top to bottom for the first set of values with a negative number in column B, then return that set of values (Column A & Column B) to any 2 cells in the spreadsheet (lets say A1 and B1)
So for instance using the attached example the macro will find the values 'Text 2' and '-0.1' and put them into the cells A1 & B1.
If no negative values are found then I want to simply exit the macro.
Thanks in advance!
Bookmarks