Adding Content Easily

[RapidFinancialSolutions]

Hi there,


So I just got an excel doc with several columns.


I added a new column, & I need to label each of the entries of the existing columns in my new column.


I know I can search for all of the cells with that one specific word (find all), but then I need to add my data (which is the same) to my new column for each of these searched entries.


How do I do that without having to paste it into each row one at a time?


Thanks

 

[hotabae]

Could you provide a "Before" and "After" of your sheet? (a couple rows should suffice).

 

[RapidFinancialSolutions]

Could you provide a "Before" and "After" of your sheet? (a couple rows should suffice).

I can't show you any of the data, but I can give you the column headings.

The column I added in was the last one Column O (Process)

All the other columns had data in them. I am working with the MID column using that to search numbers & based on those numbers, add the name of the processor.

Thanks

Hmm, I don't see a way to attach the SS

I had to use Jing

https://www.screencast.com/t/VV9DFd0GD

 

[hotabae]

Alright lemme see if I got this correct,

For the first row (2):

E2 will have a string in this format - xxxx123456

You wish to populate O2 with the name of a person that is associated with "123456"?

 

[RapidFinancialSolutions]

Alright lemme see if I got this correct,

For the first row (2):

E2 will have a string in this format - xxxx123456

You wish to populate O2 with the name of a person that is associated with "123456"?

E has tons of data in it. All different numbers. Each number has a different person associated with it. I want to search for each cell with the same numbersin E & then somehow put the name of the person associated with each of those cells in Column O with a few clicks.

I hope that explains it

 

[hotabae]

If you have a table somewhere that could act as a "translator" of sorts, then you could use Vlookup

I.E.

ON SHEET 2

[TABLE="width: 192"]
<colgroup><col width="64" style="width:48pt" span="3"> </colgroup><tbody>[TR]
[TD="width: 64, bgcolor: transparent"] [/TD]
[TD="width: 64, bgcolor: transparent"]A[/TD]
[TD="width: 64, bgcolor: transparent"]B[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]#[/TD]
[TD="bgcolor: transparent"]Name[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2[/TD]
[TD="bgcolor: transparent"]123456[/TD]
[TD="bgcolor: transparent"]Andrew[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]3[/TD]
[TD="bgcolor: transparent"]654321[/TD]
[TD="bgcolor: transparent"]Jane[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]4[/TD]
[TD="bgcolor: transparent"]456789[/TD]
[TD="bgcolor: transparent"]Petra[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]5[/TD]
[TD="bgcolor: transparent"]987654[/TD]
[TD="bgcolor: transparent"]Bean[/TD]
[/TR]
</tbody>[/TABLE]



Then you could use a formula like this in O2 (sheet1)

=VLOOKUP(E2,Sheet2!$A$2:$B$5,2)

Once O2 is how you'd like it, drag it down through all the rows

 

[RapidFinancialSolutions]

Yeh I have no idea what you are saying LOL

And why would I need to create another sheet?

I have only tried to use code once & even then the instructions I got from some YT video didn't work. I somehow managed to get it to work (add the data from one cell after another), but it was purely by accident.

I don't even know what you mean by "drag it down through all the rows."

I guess I'm going to have to manually do it.

Do you have a name for what this task is called? Maybe there's a YT video that can explain it to me.

Thanks I appreciate it.

If you have a table somewhere that could act as a "translator" of sorts, then you could use Vlookup

I.E.

ON SHEET 2

[TABLE="width: 192"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"]A[/TD]
[TD="width: 64, bgcolor: transparent"]B[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]#[/TD]
[TD="bgcolor: transparent"]Name[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2[/TD]
[TD="bgcolor: transparent"]123456[/TD]
[TD="bgcolor: transparent"]Andrew[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]3[/TD]
[TD="bgcolor: transparent"]654321[/TD]
[TD="bgcolor: transparent"]Jane[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]4[/TD]
[TD="bgcolor: transparent"]456789[/TD]
[TD="bgcolor: transparent"]Petra[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]5[/TD]
[TD="bgcolor: transparent"]987654[/TD]
[TD="bgcolor: transparent"]Bean[/TD]
[/TR]
</tbody>[/TABLE]



Then you could use a formula like this in O2 (sheet1)

=VLOOKUP(E2,Sheet2!$A$2:$B$5,2)

Once O2 is how you'd like it, drag it down through all the rows

 

[iggy_]

If you can just make up some sample data in the sample format, just a handfull of rows, and result you are looking for we can help you with this. This way you are not providing sensitive information.