Copying part of a cell and pasting it in a set of selected cells on another sheet

kfilippo

New Member
Joined
Jan 9, 2018
Messages
11
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
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Forum statistics

Threads
1,223,270
Messages
6,171,103
Members
452,379
Latest member
IainTru

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top