Pull data from specific cells on multiple worksheets onto one master sheet

**WorkforceMedia** · 03-06-2013, 09:19 AM

I'm looking for a macro/or any other shortcut to pull data from specific cells, (B1:B3, F1:F3, D37, E37, F37) into one master sheet.

I need that data to populate under headings that I've created.

Any help would be awesome.

**arlu1201** · 03-06-2013, 09:56 AM

Should B1:B3 be transposed and then pasted?

Do you want data from all sheets to be consolidated into a sheet? Is the master sheet already created and has data in it?

Should this data which is consolidated be entered into the next available row of the master sheet?

**WorkforceMedia** · 03-06-2013, 10:31 AM

Arlu - basically I want all cells B1 to fall under heading "Name," in order, all cells B2 to fall under heading "State ID" and so on. I've already created a master sheet with the headings:

B1 - Name
B2 - State ID
B3 - Career Consultant

F1 - Training Program
F2 - Provider
F3 - Funding Stream

D37 - Obligation Amount
E37 - Voucher Amount
F37 - Invoice Amount

**arlu1201** · 03-07-2013, 03:25 AM

Why dont you attach a sample file? Maybe it will clear with that.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.