Hi,
I have a problem which I cannot solve on my own. (in Excel 2007)
I am trying to merge data from different workbooks. I got to as fas as copying data from a specific column, but I would like something more advanced.
My data is divided in different named ranges (e.g. January, February, etc., I could rename them to something like table*, * meaning different number).
What I would like to do is automatically check all namedranges in each workbook (all workbooks have the same namedranges) and if in a column Price (5th column) there is numerical data in any of the cells in that 5th column, copy the whole content of that column (only what is inside namedrange) to a new summary workbook. They will be pasted to the next of each other.
If there is no numerical data in 5th column I would like to skip that namedrange and not copy/paste anything and go to the next one namedrange, when there are no ranges left go to the next file. ( I would also like to copy the name of the company – cell just above the price).
I've attached a sample data and a a summary of how it should look when it is done.
I am new to VBA so please bear with me.
I have a problem which I cannot solve on my own. (in Excel 2007)
I am trying to merge data from different workbooks. I got to as fas as copying data from a specific column, but I would like something more advanced.
My data is divided in different named ranges (e.g. January, February, etc., I could rename them to something like table*, * meaning different number).
What I would like to do is automatically check all namedranges in each workbook (all workbooks have the same namedranges) and if in a column Price (5th column) there is numerical data in any of the cells in that 5th column, copy the whole content of that column (only what is inside namedrange) to a new summary workbook. They will be pasted to the next of each other.
If there is no numerical data in 5th column I would like to skip that namedrange and not copy/paste anything and go to the next one namedrange, when there are no ranges left go to the next file. ( I would also like to copy the name of the company – cell just above the price).
I've attached a sample data and a a summary of how it should look when it is done.
I am new to VBA so please bear with me.
