Question description:
This user has given permission to use the problem statement for this
blog.
if i have two columns with part numbers on separate worksheet. Can I mirror them so that i can get the info on one speadsheet.
Solved by X. F. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
02/08/2018 - 06:50
hello..
User
02/08/2018 - 06:51
hello
Excelchat Expert
02/08/2018 - 06:51
how can i help you today?
User
02/08/2018 - 06:52
I have two spreadsheets each with over 1000 rows on them. The are almost similar, but i need them to be tha same row by row.
User
02/08/2018 - 06:52
is this possible
Excelchat Expert
02/08/2018 - 06:53
are you talking about two different file..??
User
02/08/2018 - 06:53
yes..two different files
Excelchat Expert
02/08/2018 - 06:55
If you want to compare with two different files..
Excelchat Expert
02/08/2018 - 06:55
you can split but will not sync..togather..
Excelchat Expert
02/08/2018 - 06:56
hold on..
User
02/08/2018 - 06:56
is there a merge function that may work?
User
02/08/2018 - 06:56
if you ask it to look at and compare the one column?
Excelchat Expert
02/08/2018 - 06:57
if you put them on same sheet.. you can compare..
Excelchat Expert
02/08/2018 - 06:57
[Uploaded an Excel file]
Excelchat Expert
02/08/2018 - 06:58
this is menu for two different files on split windows..
Excelchat Expert
02/08/2018 - 07:00
hold on..
Excelchat Expert
02/08/2018 - 07:00
actually you can sync..
Excelchat Expert
02/08/2018 - 07:00
hold on..
Excelchat Expert
02/08/2018 - 07:01
this is how you do it..
Excelchat Expert
02/08/2018 - 07:02
first you open two files..in Excel..
User
02/08/2018 - 07:03
OK. Both files are open
Excelchat Expert
02/08/2018 - 07:04
[Uploaded an Excel file]
Excelchat Expert
02/08/2018 - 07:04
split windows..
Excelchat Expert
02/08/2018 - 07:04
[Uploaded an Excel file]
Excelchat Expert
02/08/2018 - 07:04
now your screen should be like this..
Excelchat Expert
02/08/2018 - 07:06
if you already did, please let me know..
User
02/08/2018 - 07:06
OK..I think im there
Excelchat Expert
02/08/2018 - 07:07
make sure you should see part no in both window..
Excelchat Expert
02/08/2018 - 07:07
[Uploaded an Excel file]
User
02/08/2018 - 07:07
yes. that is correct
Excelchat Expert
02/08/2018 - 07:07
click View Side by Side and Synchronous Scrolling..
Excelchat Expert
02/08/2018 - 07:08
and if you scroll in the one window.. other window will also be scrolled
User
02/08/2018 - 07:08
where do i find that
Excelchat Expert
02/08/2018 - 07:09
View menu..
Excelchat Expert
02/08/2018 - 07:09
[Uploaded an Excel file]
Excelchat Expert
02/08/2018 - 07:09
if you see only one window..
Excelchat Expert
02/08/2018 - 07:09
you can click Arrange all, and select vertical..
Excelchat Expert
02/08/2018 - 07:10
second window will appear again..
Excelchat Expert
02/08/2018 - 07:12
did you get it..??
User
02/08/2018 - 07:14
but if i want them to merge together into one document, i still have to do this manually? With all the rows in chronological order?
Excelchat Expert
02/08/2018 - 07:15
if you want to merge together, you have use other methods..
Excelchat Expert
02/08/2018 - 07:15
it depends on how your files are structured..
Excelchat Expert
02/08/2018 - 07:15
could you upload your files in here..??
Excelchat Expert
02/08/2018 - 07:15
So I can find which way you can do it..??
User
02/08/2018 - 07:16
[Uploaded an Excel file]
User
02/08/2018 - 07:16
[Uploaded an Excel file]
User
02/08/2018 - 07:17
i want to merge these two sheets so that I get all of Matts locations with Justins parts.
Excelchat Expert
02/08/2018 - 07:17
hold on..
User
02/08/2018 - 07:17
Do you understand what i am trying to achieve?
Excelchat Expert
02/08/2018 - 07:18
Is there any duplication between Justin's part no and Matt's part no?
User
02/08/2018 - 07:20
Yes. Each sheet has almost the same part numbers one sheet has more numbers the the other
User
02/08/2018 - 07:20
**then
Excelchat Expert
02/08/2018 - 07:20
then how do you want to merge..
User
02/08/2018 - 07:21
I want Matt's locations merged with Justin's part numbers
Excelchat Expert
02/08/2018 - 07:22
hold on..
Excelchat Expert
02/08/2018 - 07:24
[Uploaded an Excel file]
Excelchat Expert
02/08/2018 - 07:24
[Uploaded an Excel file]
Excelchat Expert
02/08/2018 - 07:25
I merged matt and Justine..
Excelchat Expert
02/08/2018 - 07:25
I added new row to merge locationgroup&location for matt..
Excelchat Expert
02/08/2018 - 07:25
and copy to justin..
Excelchat Expert
02/08/2018 - 07:26
it's in the from 1105 row
Excelchat Expert
02/08/2018 - 07:26
I used vlookup to add part description for added row..
Excelchat Expert
02/08/2018 - 07:27
If partdescrition is blank.. It mean no part no found from justin..
User
02/08/2018 - 07:30
ok. I get that. Now, i want to merge the location from Matt to the part number from Justin
Excelchat Expert
02/08/2018 - 07:31
hold on..
Excelchat Expert
02/08/2018 - 07:35
[Uploaded an Excel file]
Excelchat Expert
02/08/2018 - 07:35
now you need copy part no and location.. on column A & D..
Excelchat Expert
02/08/2018 - 07:36
pink colored cells are formula to separate LocationGroup & Location..
Excelchat Expert
02/08/2018 - 07:37
[Uploaded an Excel file]
Excelchat Expert
02/08/2018 - 07:37
I found one error ..
Excelchat Expert
02/08/2018 - 07:37
I fixed it. use this file
Excelchat Expert
02/08/2018 - 07:39
[Uploaded an Excel file]
Excelchat Expert
02/08/2018 - 07:39
I added trim function to eliminate space after calculation..
Excelchat Expert
02/08/2018 - 07:40
basic formula didn't changed..
User
02/08/2018 - 07:40
am i allowed to call you?
Excelchat Expert
02/08/2018 - 07:41
don't think so..
User
02/08/2018 - 07:41
i dont think I am explaining what I need
Excelchat Expert
02/08/2018 - 07:41
sorry about that..
Excelchat Expert
02/08/2018 - 07:41
could you explain again..??
User
02/08/2018 - 07:42
Matts locations have to be matched with Justin's part numbers. I dont think we have achieved this yet
User
02/08/2018 - 07:42
where matt's part number is the same as justins
Excelchat Expert
02/08/2018 - 07:42
could you give me a example.?
Excelchat Expert
02/08/2018 - 07:42
how do you want to merge..
Excelchat Expert
02/08/2018 - 07:48
[Uploaded an Excel file]
Excelchat Expert
02/08/2018 - 07:48
do you want file like this..??
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.