populating multiple cells
is there any way to populate multiple data from different workbooks at once
using any function? EX: workbook 1 col1 col2 a 1 b 2 c 3 d 4 e 5 f 6 g 7 a 1 c 3 d 4 Workbook 2 Col1 Col2 a aa b bb c cc d dd e ee f ff g gg a aa c cc d dd In workbook 3 im trying to populate data from both wkbk 1 and 2 using the col 1 as reference. Workbook 3 COL1 COL 2 COL 3 a 1 aa b 2 bb c d e f g a c d I wanna populate col 2 and 3 at once instead of having to do 2 vlookups. Any help wld be appreciated |
Hi Nick
See this article. You may have to join to view but it costs nothing and is informative. http://techrepublic.com.com/5100-10877_11-5710152.html HTH "nick" wrote: is there any way to populate multiple data from different workbooks at once using any function? EX: workbook 1 col1 col2 a 1 b 2 c 3 d 4 e 5 f 6 g 7 a 1 c 3 d 4 Workbook 2 Col1 Col2 a aa b bb c cc d dd e ee f ff g gg a aa c cc d dd In workbook 3 im trying to populate data from both wkbk 1 and 2 using the col 1 as reference. Workbook 3 COL1 COL 2 COL 3 a 1 aa b 2 bb c d e f g a c d I wanna populate col 2 and 3 at once instead of having to do 2 vlookups. Any help wld be appreciated |
All times are GMT +1. The time now is 09:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com