Skip to Content
0
Former Member
Jun 09, 2006 at 01:29 PM

VBA code to search text and place values

22 Views

Hi all,

I've a workbook with two spreadsheets in it. One called BEx, where I've a hierarchy and the other called Balance where I want to display a few values.

I'd like a code to do a search into the BEx side and when it find the text 'Assets' (all the texts are in column A), take its value from column B and place into cell B10 in the other spreadsheet.

Is is possible ?