PDA

View Full Version : Search for and extract data from one Excel workbook and paste in another Excel workb



NatsJou
06-30-2014, 06:21 AM
We work in two workbooks. In one workbook (WB1) we have a sheet with a summary of all the departments and figures for every month. (there is a workbook for every month).

In the second workbook (WB2) we have various sheets (a sheet for every department). We currently manually copy and paste data from WB1 (from the summary sheet) into every single departments sheet in WB2. We use various months, thus various different WB1's to complete WB2.

Each department also has two different sides.

I want to copy data from WB1 by searching a departments name and copy the departments data under the correct column in WB2 in the correct departments sheet.

See attached file for example.11885