Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I combine two worksheets in EXCEL 2003
I have two worksheets.
One contains the columns of Name, Birthday, and Phone. The second one contains the columns of Name and Anniversary. I want to combine the two worksheets into one worksheet that would include all the columns, that is: Name Birthday Anniversary Phone How can I accomplish this? I will appreciate advice. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I combine two worksheets in EXCEL 2003
You can do a vlookup in the 4th column on the 1st worksheet
So it would be Vlookup(Name,2ndWorksheet!Range,2,False) So for an example if the first name is in cell A2 on the 1st sheet And the 2nd sheet has Names starting in A2 and ending A100 with the Anniversary in column B. The formula would like this. You put this formula wherever you want the anniversary to show up Vlookup(A2,'Sheet2'!A2:B100,2,False) And then copy and paste this formula down to wherever your last row of data is. "Robert Judge" wrote: I have two worksheets. One contains the columns of Name, Birthday, and Phone. The second one contains the columns of Name and Anniversary. I want to combine the two worksheets into one worksheet that would include all the columns, that is: Name Birthday Anniversary Phone How can I accomplish this? I will appreciate advice. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I combine two worksheets in EXCEL 2003
Hi:
Thanks. But the formula I am entering is producing an error message: #NA In my original post, I deliberately made the column names I provided different and I thought, simpler than they really are. I thought that might help someone to provide an answer more easily. However, perhaps if I provide an exact listing of the columns, you can give me a revised "Vlookup" function that will work. Sheet #1 has many columns, including these columns: C = First Name E = Last Name T = Birthday (in the format 2/6/2008) Sheet #2 has fewer columns, including these: A = First Name B = Last Name D = Years old (in the format "20" for someone twenty years old) E = Phone number I want to create a new worksheet that will include all the columns in both worksheets, including these columns, drawing from the rows in the two different worksheets: First Name Last Name Birthday Years Old Phone number Thanks for any further help you can provide! - Bob Judge ------------------------------------------------------------------- "akphidelt" wrote: You can do a vlookup in the 4th column on the 1st worksheet So it would be Vlookup(Name,2ndWorksheet!Range,2,False) So for an example if the first name is in cell A2 on the 1st sheet And the 2nd sheet has Names starting in A2 and ending A100 with the Anniversary in column B. The formula would like this. You put this formula wherever you want the anniversary to show up Vlookup(A2,'Sheet2'!A2:B100,2,False) And then copy and paste this formula down to wherever your last row of data is. "Robert Judge" wrote: I have two worksheets. One contains the columns of Name, Birthday, and Phone. The second one contains the columns of Name and Anniversary. I want to combine the two worksheets into one worksheet that would include all the columns, that is: Name Birthday Anniversary Phone How can I accomplish this? I will appreciate advice. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I combine two worksheets in EXCEL 2003
Alright, well you need some common value between the two worksheets in order
to correctly join them. For instance... Last Name If there is different last names in every cell you can use the last name as your vlookup. If there are multiple common last names then create a dummy column where you combine the first and last names... which would look like =A1&B1... that is if the last name was in column A and first name in column B What I'm trying to get at is that it is mandatory that you find some characteristic between the two sheets that share some common value. Then do the vlookup to get sheet 2s data. Let me know if this helps. "Robert Judge" wrote: Hi: Thanks. But the formula I am entering is producing an error message: #NA In my original post, I deliberately made the column names I provided different and I thought, simpler than they really are. I thought that might help someone to provide an answer more easily. However, perhaps if I provide an exact listing of the columns, you can give me a revised "Vlookup" function that will work. Sheet #1 has many columns, including these columns: C = First Name E = Last Name T = Birthday (in the format 2/6/2008) Sheet #2 has fewer columns, including these: A = First Name B = Last Name D = Years old (in the format "20" for someone twenty years old) E = Phone number I want to create a new worksheet that will include all the columns in both worksheets, including these columns, drawing from the rows in the two different worksheets: First Name Last Name Birthday Years Old Phone number Thanks for any further help you can provide! - Bob Judge ------------------------------------------------------------------- "akphidelt" wrote: You can do a vlookup in the 4th column on the 1st worksheet So it would be Vlookup(Name,2ndWorksheet!Range,2,False) So for an example if the first name is in cell A2 on the 1st sheet And the 2nd sheet has Names starting in A2 and ending A100 with the Anniversary in column B. The formula would like this. You put this formula wherever you want the anniversary to show up Vlookup(A2,'Sheet2'!A2:B100,2,False) And then copy and paste this formula down to wherever your last row of data is. "Robert Judge" wrote: I have two worksheets. One contains the columns of Name, Birthday, and Phone. The second one contains the columns of Name and Anniversary. I want to combine the two worksheets into one worksheet that would include all the columns, that is: Name Birthday Anniversary Phone How can I accomplish this? I will appreciate advice. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I combine two worksheets in EXCEL 2003
Dear Akphidelt:
Thanks for staying with me on this. OK, let me provide some more information. Both sheets have First Name and Last Name columns. Some of the names are common to both sheets. For instance, John Smith and Mary Jones may be on both sheets. However, the first sheet may have John Jones, who is not on the second sheet, and the second sheet may have Mary Adams, who is not on the first sheet. My previous post provided the exact Column names of each sheet. Unfortuntely, when you instruct to do the " vlookup to get sheet 2s data," I get lost. I don't understand the function enough to be able to create it properly. With the information above and in my previous email, can you give me the function exactly and tell me where to put it? Thanks again for any further help you can provide. - Robert Judge ------------------------------------------------------------ "akphidelt" wrote: Alright, well you need some common value between the two worksheets in order to correctly join them. For instance... Last Name If there is different last names in every cell you can use the last name as your vlookup. If there are multiple common last names then create a dummy column where you combine the first and last names... which would look like =A1&B1... that is if the last name was in column A and first name in column B What I'm trying to get at is that it is mandatory that you find some characteristic between the two sheets that share some common value. Then do the vlookup to get sheet 2s data. Let me know if this helps. "Robert Judge" wrote: Hi: Thanks. But the formula I am entering is producing an error message: #NA In my original post, I deliberately made the column names I provided different and I thought, simpler than they really are. I thought that might help someone to provide an answer more easily. However, perhaps if I provide an exact listing of the columns, you can give me a revised "Vlookup" function that will work. Sheet #1 has many columns, including these columns: C = First Name E = Last Name T = Birthday (in the format 2/6/2008) Sheet #2 has fewer columns, including these: A = First Name B = Last Name D = Years old (in the format "20" for someone twenty years old) E = Phone number I want to create a new worksheet that will include all the columns in both worksheets, including these columns, drawing from the rows in the two different worksheets: First Name Last Name Birthday Years Old Phone number Thanks for any further help you can provide! - Bob Judge ------------------------------------------------------------------- "akphidelt" wrote: You can do a vlookup in the 4th column on the 1st worksheet So it would be Vlookup(Name,2ndWorksheet!Range,2,False) So for an example if the first name is in cell A2 on the 1st sheet And the 2nd sheet has Names starting in A2 and ending A100 with the Anniversary in column B. The formula would like this. You put this formula wherever you want the anniversary to show up Vlookup(A2,'Sheet2'!A2:B100,2,False) And then copy and paste this formula down to wherever your last row of data is. "Robert Judge" wrote: I have two worksheets. One contains the columns of Name, Birthday, and Phone. The second one contains the columns of Name and Anniversary. I want to combine the two worksheets into one worksheet that would include all the columns, that is: Name Birthday Anniversary Phone How can I accomplish this? I will appreciate advice. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I combine five EXCEL 2003 workbooks into one? | Excel Discussion (Misc queries) | |||
How do I combine five Excel 2003 workbooks? | Excel Worksheet Functions | |||
I need to combine two excel worksheets in one pivot table. | Excel Discussion (Misc queries) | |||
How do I merge or combine 2 excel worksheets by a common collumn? | Excel Worksheet Functions | |||
How do I combine two worksheets in Excel? | New Users to Excel |