Thread
:
Combine data in columns from 2 tabs
View Single Post
#
4
Posted to microsoft.public.excel.misc
Peo Sjoblom
external usenet poster
Posts: 3,268
Combine data in columns from 2 tabs
It won't make any difference using formulas, if anything it is slower. If
you have duplicates
http://www.cpearson.com/excel/Duplicates.aspx
use the method above and delete the duplicates or use code
http://www.rondebruin.nl/tips.htm
look at the merge examples
--
Regards,
Peo Sjoblom
"Cong Nguyen" wrote in message
...
Andy,
Thanks for your response. But, my worksheet has too many of these and I
need
a formula.
--
Cong Nguyen
"Andy Smith" wrote:
It's two simple copy-and paste operations.
--
* Please click Yes if this was helpful *
Andy Smith
Senior Systems Analyst
Standard and Poor''s, NYC
"Cong Nguyen" wrote:
Please show me how to combine data in columns from 2 different tabs:
TAB1
COL.A COL.B COL.C
RANK P/N S/N
1 A 27
28
2 B 12
5
8
3 C 43
55
TAB2
COL.A COL.B COL.C
RANK P/N S/N
1 E 67
9
11
2 F 20
7
3 G 1
66
Final data should look like:
COL.A COL.B COL.C
RANK P/N S/N
1 A 27
28
2 B 12
5
8
3 C 43
55
1 E 67
9
11
2 F 20
7
3 G 1
66
Thank you.
--
Cong Nguyen
Reply With Quote
Peo Sjoblom
View Public Profile
Find all posts by Peo Sjoblom