nicksinthemi
11-17-2011, 05:49 AM
I'm trying to get a grasp of how I might get an entire column from one sheet to another. Problem is this spans two separate workbooks. Can macros do this?
The other thing this has to do is loop through the second workbook because the column has to go onto a specific sheet and in a specific place. At first this looks easy because the top line of the first sheet has the sheet name of the other workbook. That second workbook has a list of values in the top row (X001, X002, etc.). But where I'm getting confused is the function for matching before the paste happens.
Another way of describing it that it is a bit of a backwards problem - it's like I'm trying to de-consolidate a set of columns. I have X001, X009, X014 for example with hundreds of values below. But I want to get this into a form where there are loads of blank rows - X001, X002, X003 and so on.
Where do I start looking? Loop and match?
The other thing this has to do is loop through the second workbook because the column has to go onto a specific sheet and in a specific place. At first this looks easy because the top line of the first sheet has the sheet name of the other workbook. That second workbook has a list of values in the top row (X001, X002, etc.). But where I'm getting confused is the function for matching before the paste happens.
Another way of describing it that it is a bit of a backwards problem - it's like I'm trying to de-consolidate a set of columns. I have X001, X009, X014 for example with hundreds of values below. But I want to get this into a form where there are loads of blank rows - X001, X002, X003 and so on.
Where do I start looking? Loop and match?