Got function that will pull 2 columns out of multiple worksheets in single workbook?

**XLStumped** · 12-03-2013, 09:21 PM

Hi,

I need to pull (the same) 2 columns out of several worksheets in a single workbook and create one array containing these columns. There isn't any criteria about what rows to select, other than maybe blanks....

Does anyone know a way to make that simpler? It is something that needs to be done periodically - monthly I think.

TY, XLStumped

**alansidman** · 12-03-2013, 10:07 PM

Can you provide a sample workbook showing what you want done? It is always easier to supply a good solution if there is a visual.

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Got function that will pull 2 columns out of multiple worksheets in single workbook?

LinkBack

Thread Tools

Rate This Thread

Display

Got function that will pull 2 columns out of multiple worksheets in single workbook?

Re: Got function that will pull 2 columns out of multiple worksheets in single workbook?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Pull data if there is any from a single column in multiple worksheets into a single sheet

Need help to Pull information out of a Single Cell and into Multiple columns

[SOLVED] Copying Worksheets from Multiple Workbooks to a Single Workbook, Separate Worksheets

Copying Worksheets from Multiple Workbooks to a Single Workbook, Separate Worksheets

Copying Multiple worksheets in Multiple workbooks to one single workbook

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions