Hello guys & gals,
I tried using the search section and I'm not really finding what I'm looking for, so I will try to ask it here. (and if there is a topic on this same thing please redirect me)
Sheet 1 A1-A3 is where I would like to place a specific text item from Sheet 2 Column A.
In Column A on Sheet 2 There is random text throughout the column. This data changes every time I use my macro button to pull in data from a website.
What I am trying to do is find the cell that start with "TAF" & the coresponding cells below ( all the becmg texts )
I cant just do a sheet 1 a1 = sheet 2 specific cell because sometimes the "TAF" portion changes to a different row #.
Is there a way to find "TAF" in column A in sheet 2 and take all the text in that column and put it in Sheet 1 A1, and then take everything below that and put in on sheet 1 as well?
Below is a picture of "sheet 2" ... sheet 1 you can imagine is blank.
Thanks!
RP
I tried using the search section and I'm not really finding what I'm looking for, so I will try to ask it here. (and if there is a topic on this same thing please redirect me)
Sheet 1 A1-A3 is where I would like to place a specific text item from Sheet 2 Column A.
In Column A on Sheet 2 There is random text throughout the column. This data changes every time I use my macro button to pull in data from a website.
What I am trying to do is find the cell that start with "TAF" & the coresponding cells below ( all the becmg texts )
I cant just do a sheet 1 a1 = sheet 2 specific cell because sometimes the "TAF" portion changes to a different row #.
Is there a way to find "TAF" in column A in sheet 2 and take all the text in that column and put it in Sheet 1 A1, and then take everything below that and put in on sheet 1 as well?
Below is a picture of "sheet 2" ... sheet 1 you can imagine is blank.
Thanks!
RP