G
Guest
I am trying to select a cell on another sheet as follows:
searche Sheet2 for the text located in Sheet1 A1.
(I can do this first step)
Now, I want to search only the column of the previous search result for text
located in Sheet1 A2.
I have used this code which I found in a previous post to do the first part
of the search.
x = ActiveCell
y = Sheets("monthly budget").Cells.Find(x).Address
Application.Goto Sheets("monthly budget").Range(y), Scroll:=True
I have also stumbled around with my limited knowledge and have accomplished
my desired result, but it is very messy and requires jumping back and forth
from sheet to sheet with copying and pasting. I know there has to be a better
way.
thanks in advance,
Melissa
searche Sheet2 for the text located in Sheet1 A1.
(I can do this first step)
Now, I want to search only the column of the previous search result for text
located in Sheet1 A2.
I have used this code which I found in a previous post to do the first part
of the search.
x = ActiveCell
y = Sheets("monthly budget").Cells.Find(x).Address
Application.Goto Sheets("monthly budget").Range(y), Scroll:=True
I have also stumbled around with my limited knowledge and have accomplished
my desired result, but it is very messy and requires jumping back and forth
from sheet to sheet with copying and pasting. I know there has to be a better
way.
thanks in advance,
Melissa