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.