**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.*