Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi All:
I need to merge two variables but I could not find any instructions on this issue. I have a data sheet 1 like this: Course Hours Acc100 3.0 Acc122 3.0 Mar095 3.5 Bus100 4.0 Bus101 3.0 I have data sheet 2 like: Course Instructor Acc100 Charles Acc101 David Acc122 James Mar095 Mary Mar100 Greg Mar155 Sharon Bus100 Lisa Bus101 Sue Bus105 Tom Data sheet 1 and data sheet 2 have the same variable Course. Course contains much more records in data sheet 2 and all records of Course in data sheet 1 are included in Course in data sheet 2. Now I want to merge these two sheets to create file like: Course Instructor Hours Acc100 Charles 3.0 Acc122 James 3.0 Mar095 Mary 3.5 Bus100 Lisa 4.0 Bus101 Sue 3.0 Is there is anyone who could tell me the procefures I can accomplish this goal? Any suggestions and advices are greatly appreciated. Charles |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Transfer data from sheet to sheet | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Automatic cell increment with data from sheet 1 to sheet 2 | Excel Worksheet Functions | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions |