G
Guest
I don't know if there is a way to do this but if anyone can tell me, it would
save me days of work.
I have 2 sheets, one with many columns of numbers but one column with
identifier numbers (Sheet 1, column a) and anotehr sheet with with 2 columns
of #'s (sheet 2, column b and c).
Column A and Column B both contain common identifier #'s (column B only has
1500 of 3000 total while Column A has all 3000).
What I want to do is merge sheet 1 and 2 with the Sheet 2 two identifier #'s
matching positions (i.e. row) with the Sheet 1 identifier #'s.
Otherwise i will have to manually move data for 1300 cells from sheet 2 to
sheet one. Doable but tedious.
Any shortcuts?
Thanks
anand
save me days of work.
I have 2 sheets, one with many columns of numbers but one column with
identifier numbers (Sheet 1, column a) and anotehr sheet with with 2 columns
of #'s (sheet 2, column b and c).
Column A and Column B both contain common identifier #'s (column B only has
1500 of 3000 total while Column A has all 3000).
What I want to do is merge sheet 1 and 2 with the Sheet 2 two identifier #'s
matching positions (i.e. row) with the Sheet 1 identifier #'s.
Otherwise i will have to manually move data for 1300 cells from sheet 2 to
sheet one. Doable but tedious.
Any shortcuts?
Thanks
anand