Hello,
I have a table and only some information of it interests me. i'll try to Picture here what I'm having difficulties to do.
On column A of my table, I've got some information related to account numbers. So, for example, on cell A4, is written: " account - xxxx - services transfers".
From cell A5 to A12, there are some infomation that does not interest me. But on other columns on rows 5 to 12, there are information that I need to keep.
What interests me here is the number "xxxx" on cell A4, that's what I want to extract. Also, I need this account number "xxx" to be displayed on all cells A5 to A12 (the rows that I have information on other columns to keep).
The thing is, it´s a long table with lots of sets of rows divided by texts like " account - xxxx - services transfers". So, for example, on cell A13, i´ve " account - yyyy - services transfers". Now I need to extract the "yyyy" number and paste it on cells A14 to A19.
And the set of rows that I need this account number to appear is not fixed. So, what i would like was a macro that would identify this number that comes after "account", extract it and paste on cells that are referenced to this account. And do this for all sets of operations that are sub-divided in the accounts.
Also, I'm working with 2 sheets. One for the raw data (sheet 1), and the other for the treated data (sheet 2). So, this number "xxxx" I'm looking for would be displayed on rows of column A of sheet 2.
I'm not sure if I made myself clear. i can try to explain better if people are not understanding.
Thank you in advance
I have a table and only some information of it interests me. i'll try to Picture here what I'm having difficulties to do.
On column A of my table, I've got some information related to account numbers. So, for example, on cell A4, is written: " account - xxxx - services transfers".
From cell A5 to A12, there are some infomation that does not interest me. But on other columns on rows 5 to 12, there are information that I need to keep.
What interests me here is the number "xxxx" on cell A4, that's what I want to extract. Also, I need this account number "xxx" to be displayed on all cells A5 to A12 (the rows that I have information on other columns to keep).
The thing is, it´s a long table with lots of sets of rows divided by texts like " account - xxxx - services transfers". So, for example, on cell A13, i´ve " account - yyyy - services transfers". Now I need to extract the "yyyy" number and paste it on cells A14 to A19.
And the set of rows that I need this account number to appear is not fixed. So, what i would like was a macro that would identify this number that comes after "account", extract it and paste on cells that are referenced to this account. And do this for all sets of operations that are sub-divided in the accounts.
Also, I'm working with 2 sheets. One for the raw data (sheet 1), and the other for the treated data (sheet 2). So, this number "xxxx" I'm looking for would be displayed on rows of column A of sheet 2.
I'm not sure if I made myself clear. i can try to explain better if people are not understanding.
Thank you in advance