Results 1 to 2 of 2

Thread: Insert range?

  1. #1
    New Lounger
    Join Date
    Feb 2012
    Thanked 0 Times in 0 Posts

    Insert range?

    I'd like to use Excel data with Word mail merge to populate data to a monthly report in Word format. Since Word's mail merge limits one record per document but I need to use data from multiple months, I thought I'd assign a range to the data for each month in Excel and then create a new spreadsheet for each month, inserting the ranges as a single record. Is there a formula for inserting an existing range into a new sheet?

    Am I making this too hard? Is there an easier way to do what I need to do?


  2. #2
    3 Star Lounger
    Join Date
    Nov 2002
    New York, New York, USA
    Thanked 20 Times in 20 Posts
    Dear NCDoc:

    Welcome to the lounge.

    Range Names in Excel can be limited in scope. In other words, you can make a range name to be global or limited to one sheet.

    In you case I would suggest the following:

    Create a range name for month 1 and limit the range scope to current worksheet.

    Next select the worksheet tab right click and copy the entire sheet somewhere within the workbook

    This should give you an exact copy of the entire sheet including the range name. However the range name will reference the new copy while the original sheet same range name will reference the orginal sheet.

    If neede for your project you can delete the range name on the original sheet.

    How to limit the scope of a range name:

    1. Select the range you want to copy
    2. On the Ribbon Select Formulas
    3. Select Define Names (a dialog box will appear)
    4. Type in a valid range name
    5. In the Scope drop down Box limit the scope to the active worksheet.
    6. Click on OK

    I hope htis helps if not just post a follow up question


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts