**Question description:**

*This user has given permission to use the problem statement for this
blog.*

I want to replace entire column............................................

Solved by B. B. in 40 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

User
19/06/2018 - 05:04

hio

User
19/06/2018 - 05:04

hi

Excelchat Expert
19/06/2018 - 05:04

Hi Welcome to Got it Pro

Excelchat Expert
19/06/2018 - 05:05

Can you please share your excel sheet

User
19/06/2018 - 05:05

i cant

User
19/06/2018 - 05:06

it confientia;ll

Excelchat Expert
19/06/2018 - 05:06

Just create dummy data and share it with me

Excelchat Expert
19/06/2018 - 05:06

Its just for better understanding and results

User
19/06/2018 - 05:06

i just want to replace one column of one sheet witrh the similar column from the another sheet

Excelchat Expert
19/06/2018 - 05:08

Replace means.

Excelchat Expert
19/06/2018 - 05:08

do you have any unique Id?

Excelchat Expert
19/06/2018 - 05:10

Are you there with me?

Excelchat Expert
19/06/2018 - 05:10

If you want to replace just copy paste..

Excelchat Expert
19/06/2018 - 05:10

If you want to replace based on some unique Id you can use Formulas.

Excelchat Expert
19/06/2018 - 05:10

Request you to create some dummy data and share it with me so that will give better results

User
19/06/2018 - 05:13

hi

Excelchat Expert
19/06/2018 - 05:13

Are you there with me

User
19/06/2018 - 05:13

sorry i had to be away

Excelchat Expert
19/06/2018 - 05:13

No Problem

User
19/06/2018 - 05:14

ok.. now i have created dummy on the worksheet that ius deiplayed with chat window

Excelchat Expert
19/06/2018 - 05:14

is it Just minute

User
19/06/2018 - 05:14

can you see thta

Excelchat Expert
19/06/2018 - 05:14

Not yet. Can you send the sheet

User
19/06/2018 - 05:15

i m looking for share buttoin on tht

Excelchat Expert
19/06/2018 - 05:15

in your chat window there is a attachement icon

User
19/06/2018 - 05:15

how do i share tht

User
19/06/2018 - 05:15

ok

User
19/06/2018 - 05:15

thenm?

Excelchat Expert
19/06/2018 - 05:16

Just click and select the file

Excelchat Expert
19/06/2018 - 05:16

Or give me one minute let me refresh my page

User
19/06/2018 - 05:16

yupp

User
19/06/2018 - 05:16

coz i hv just created on this website.

Excelchat Expert
19/06/2018 - 05:16

Sure.Please hold on

User
19/06/2018 - 05:17

in this i want to replace col. B of sheet 1 with col. B off sheet 2

Excelchat Expert
19/06/2018 - 05:18

Just a minute

User
19/06/2018 - 05:18

k

Excelchat Expert
19/06/2018 - 05:20

Can you please check and confirm

Excelchat Expert
19/06/2018 - 05:20

Sheet1 Contains only 14 values but sheet2 contains more than 14 rows.

User
19/06/2018 - 05:21

yes

Excelchat Expert
19/06/2018 - 05:21

I just created New value in Column C ...

Excelchat Expert
19/06/2018 - 05:22

Please confirm whether result is correct or not

User
19/06/2018 - 05:23

k

User
19/06/2018 - 05:23

i can seee

Excelchat Expert
19/06/2018 - 05:23

Thank you. Waiting for your confirmation.

User
19/06/2018 - 05:23

it still does not solve

Excelchat Expert
19/06/2018 - 05:24

Yes. Please tell me your need let me solve it.

Excelchat Expert
19/06/2018 - 05:24

Sheet1 - There are around 14 values.

Excelchat Expert
19/06/2018 - 05:24

Copy of Sheet1 - There are around 23 Values

Excelchat Expert
19/06/2018 - 05:25

What kind of replacement you are expecting give me one example so that I will help you to solve

Excelchat Expert
19/06/2018 - 05:27

Are you there with me?

User
19/06/2018 - 05:28

ok

User
19/06/2018 - 05:28

how do i do in my sheeet

User
19/06/2018 - 05:28

sorry i m at work so get to be off in between

Excelchat Expert
19/06/2018 - 05:28

Ok..

Excelchat Expert
19/06/2018 - 05:29

Do you have two books or sheets?

User
19/06/2018 - 05:32

yupp

Excelchat Expert
19/06/2018 - 05:33

If you spend 5 minutes we will finish it quickly.

User
19/06/2018 - 05:33

two sheets but sht 2 is copied from sht 1, then edited and now I want a col. of sht 1 to be replaced with col of sht 2

Excelchat Expert
19/06/2018 - 05:35

I think there is no changes in first 15 rows in your sheet1 and copy of sheet1

User
19/06/2018 - 05:35

yupp.

User
19/06/2018 - 05:35

but what if sht s col. is changeed a lot

Excelchat Expert
19/06/2018 - 05:36

Please check sheet 1 result column C

Excelchat Expert
19/06/2018 - 05:36

It will be as per copy of sheet 1

User
19/06/2018 - 05:38

ok.. thanks for your help..

Excelchat Expert
19/06/2018 - 05:38

your welcome :)

Excelchat Expert
19/06/2018 - 05:39

If you want simple replace just copy paste

Excelchat Expert
19/06/2018 - 05:39

it will solve your issue or you can use this approach as well.

Excelchat Expert
19/06/2018 - 05:39

Create one column for SNo...(Column A) in both sheets and use vlookup function.

Excelchat Expert
19/06/2018 - 05:42

Are you there?

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*