benajamingeldart
New Member
- Joined
- Dec 10, 2006
- Messages
- 15
Hi folks, I need some help.
I have 2 workbooks, WB1 contains loads of data and WB2 contains a list of all the worksheets in WB1 against which I want to copy and paste part of the data from WB1 into a WB2 summary table.
I have a macro called 'Pulldata' which will search for a cell value and copy a range of data but have no way of automating this back into WB2 against the correct worksheet name then moving onto the next value in the WB1 list.
Any way of doing this with VBA looping or a vba vlookup worksheet name or something.
Thanks.
Ben
I have 2 workbooks, WB1 contains loads of data and WB2 contains a list of all the worksheets in WB1 against which I want to copy and paste part of the data from WB1 into a WB2 summary table.
I have a macro called 'Pulldata' which will search for a cell value and copy a range of data but have no way of automating this back into WB2 against the correct worksheet name then moving onto the next value in the WB1 list.
Any way of doing this with VBA looping or a vba vlookup worksheet name or something.
Thanks.
Ben