petegrant89
New Member
- Joined
- Jun 28, 2011
- Messages
- 21
Hello,
I am realtively new to VBA and feel that the macro that I need to create is a bit beyond my skill level.
Essentially I need to have a workbook with 4 sheets. In sheet 1 I need to paste a large amount of data from a forecast (columns A-AD and about 8000 rows long), in sheet 2 I need to paste another, similar forecast from a different time period. I want sheet 3 to consist of the rows of sheets 1 and 2 that contain the same portfolio name (call it column A), stacked on top of each other so I can analyze the forecasts. Sheet 4, I need to contain every row that was not contained in BOTH sheets 1 and 2.
Any help would be greatly appreciated.
I am realtively new to VBA and feel that the macro that I need to create is a bit beyond my skill level.
Essentially I need to have a workbook with 4 sheets. In sheet 1 I need to paste a large amount of data from a forecast (columns A-AD and about 8000 rows long), in sheet 2 I need to paste another, similar forecast from a different time period. I want sheet 3 to consist of the rows of sheets 1 and 2 that contain the same portfolio name (call it column A), stacked on top of each other so I can analyze the forecasts. Sheet 4, I need to contain every row that was not contained in BOTH sheets 1 and 2.
Any help would be greatly appreciated.
