I downloaded the add-in, but it was not what I was looking to do, or maybe I
don't understand it. Let's say I have 2 different spreadsheets. One is for
sales, and it has 4 different tabs for each region (north, east, south,
west). The other spreadsheet is for Receivables. There is a separate tab
for each region (north, east, south, west). I want to send both of these
spreadsheets to my senior management. I want them to open the spreadsheet,
click on sales and be able to click on all 4 tabs. Also, I'd want them to be
able to do the same with receivables. The spreadsheets are independent of
each other and don't share any of the same information.
"Gord Dibben" wrote:
> You question was clear to me and I believe to Luke.
>
> You asked how to combine several workbooks and their worksheets into one
> large workbook.
>
> Luke pointed you to Ron's site for an add-in to help you.
>
> I guess you did not have a look or................?
>
> If you don't want the add-in and are a DIY person see Ron's site here.
>
> http://www.rondebruin.nl/tips.htm
>
> Scroll down to copy/paste/merge examples and choose the code you need.
>
>
>
> Gord Dibben MS Excel MVP
>
> On Fri, 9 Apr 2010 10:51:02 -0700, jydoug <(E-Mail Removed)>
> wrote:
>
> >I guess my question wasn't clear. I don't want to Merge anything. I just
> >want to have one file to open with several diffent reports in the file.
> >
> >"Luke M" wrote:
> >
> >> See Ron's add-in:
> >> http://www.rondebruin.nl/merge.htm
> >>
> >> --
> >> Best Regards,
> >>
> >> Luke M
> >> "jydoug" <(E-Mail Removed)> wrote in message
> >> news:4B4D0BE2-B9E0-4B21-AEAB-(E-Mail Removed)...
> >> > Is their a way to combine several different spreadsheets with multiple
> >> > worksheets into one file. I want one large file that you can open and
> >> > view
> >> > several different reports at the same time.
> >>
> >>
> >> .
> >>
>
> .
>
Similar Threads
