I have a workbook (we'll call A) that has 13 sheets in it. I need the values from sheet 2 to be transferred to a different workbook (B), sheet 1. However the cells don't line up between the 2 sheets.
Workbook A sheet 13 is my input page.
I want to make a combo box that the user can pull down the Month they want information for and workbook b sheet 1 will automatically be updated with that data.
I'm quite a novice when it comes to VBA so all help is appreciated.
Workbook A sheet 13 is my input page.
I want to make a combo box that the user can pull down the Month they want information for and workbook b sheet 1 will automatically be updated with that data.
I'm quite a novice when it comes to VBA so all help is appreciated.