Fill Handle Questions

[helios_lie]

Hi, I have a data which is like this:

Cell A B
1 garbage Myformulahere
2 garbage
3 data = 500
4 garbage
5 garbage
6 data = 1000
...

I would like to collect the data from cell A3, A6 and so on... (ie take the values 500, 1000 and so on)

I use this formula in my cell B1 and B2
$B1 = VALUE(MID(A3,SEARCH("=",A3)+1,LEN(A3)-SEARCH("=",A3)))
$B2 = VALUE(MID(A6,SEARCH("=",A6)+1,LEN(A6)-SEARCH("=",A6)))

I would like to continue this pattern, that is to take data from A9, A12 and copy them to $B3, $B4 and so on. However when I use the fill handle I cannot get the data that I want. May I know if there is any way to do this?

Thank you in advance.

[Portuga]

I came across this issue several times. Maybe there is an easier way to do this, but I use a work around that works and it takes less time then manually ajusting the data. (depends on the amount of data of course, but when talking hundreds or thousands of rows, deff worth it)

For example, in D1 if you write "A3" and in D2 "A6" and use the fill handle there, it will show "A9" in D3.

What I do then, is to break the formula down into parts and then concatenate it back again using the values from column D.
Then is a matter of copy, paste values. and seach and replace all "=" with "=" to activate the formulas automatically.

See attached