I need to link information from one workbook to another workbook. What formula do I use? Example:
Workbook 1 has one worksheet --
Column A has several different client #s (some #s will be repeated in several rows)
Columns B-E has information regarding the clients
Workbook 2 will have a worksheet for each client --
I want Columns A-D to get the information from columns B-E of the first workbook based on the client #
Any help with this would be very appreciated
Workbook 1 has one worksheet --
Column A has several different client #s (some #s will be repeated in several rows)
Columns B-E has information regarding the clients
Workbook 2 will have a worksheet for each client --
I want Columns A-D to get the information from columns B-E of the first workbook based on the client #
Any help with this would be very appreciated