Transferring data from workbook to workbook

HollyN

Board Regular
Joined
Jun 9, 2004
Messages
59
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.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Watch MrExcel Video

Forum statistics

Threads
1,118,285
Messages
5,571,310
Members
412,381
Latest member
RogerL
Top