Consolidating multiple workbooks and worksheets

**uttamad** · 04-18-2013, 06:08 PM

HI Everyone,
I am trying to consolidate multiple workbooks and worksheets using vba. I am having a problem with consolidating multiple cells, i can't use range method because they are not in consecutive rows or column. I have to consolidate cells from multiple workbooks with multiple worksheets, cells to consolidate are something like F3, F11, F19, F27 etc... Currently I am using this to just select one cell:

With mybook.Worksheets("Monthly Metrics report")
Set sourceRange = .Range("F3")

It would be great if i could get any type of help with this.

Thank you in Advance.

**arlu1201** · 04-19-2013, 04:16 AM

Can you post your entire code here which consolidates the workbooks, so we can help you fit this piece in?

**uttamad** · 04-19-2013, 05:01 PM

Hi,Below you can find the entire code:

Please Login or Register  to view this content.

Thanks

**arlu1201** · 04-20-2013, 01:51 AM

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.