Albert Wijn
New Member
- Joined
- May 6, 2002
- Messages
- 2
dear reader
Could you please help me,
I have following problem;
In Workbook "A" sheet1 cell B3 has a "name"
In Workbook "B" sheet1 contains in column 2 several cells corresponding "name"
I am trying already for a longer time now to create a macro with the result that all data in Workbook "B" column 1,3,5 are copied to Workbook "A".
So there should be a search function for "name" out of Workbook "A", and that find in column 2 from Workbook "B" all the corresponding cells and than copy the data from column 1,3,5 of these corresponding cell's to Workbook "A"
hope this explains my problem, could you help me?
many thanks
Albert
Could you please help me,
I have following problem;
In Workbook "A" sheet1 cell B3 has a "name"
In Workbook "B" sheet1 contains in column 2 several cells corresponding "name"
I am trying already for a longer time now to create a macro with the result that all data in Workbook "B" column 1,3,5 are copied to Workbook "A".
So there should be a search function for "name" out of Workbook "A", and that find in column 2 from Workbook "B" all the corresponding cells and than copy the data from column 1,3,5 of these corresponding cell's to Workbook "A"
hope this explains my problem, could you help me?
many thanks
Albert