Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can I join a cell in one worksheet with another cell in another worksheet
within the same workbook? Sheet 1 has A2 (Employee Id) with hourly rate in B2 Sheet 2 has A2 (Employee Id), B2 (Hours) and I'm trying to calculate Pay in C2 by multiplying the hourly rate from Sheet 1: B2 (hourly rate) with Sheet 2: B2 (Hours) Any ideas? The problem is that Sheet 2 has multiple entries for employee id. It is a one to many. Amy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to join word in one cell | Excel Worksheet Functions | |||
Join tables like inner join in Access | Excel Discussion (Misc queries) | |||
Delete Spaces and Join Text in Cell | Excel Worksheet Functions | |||
Worksheet version of VBA JOIN | Excel Programming |