+ Reply to Thread
Results 1 to 4 of 4

New spreadsheet for each cell (list) with references

  1. #1
    Registered User
    Join Date
    08-31-2011
    Location
    Boston, MA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question New spreadsheet for each cell (list) with references

    Hello,

    I NEED HELP

    I need a macro that creates a new spreadsheet for a range of cells. Also i need the created spreadsheets to have data already in it. The data is a checklist. For every checklist I wanted 3 cells referenced from the original spreadsheet.

    Is this even possible?

    For example...

    Name Date of Birth Customer Numer
    Alex 8/1/1965 789123
    Nick 4/2/1973 987421
    Steve 6/30/1985 85632
    Ted 1/5/1988 976218


    I would like each spreadsheet to have the name in a certain cell... the date of birth on another cell... and the customer number in another cell.

    On the new spreadsheets I would like a checklist of various things as if it were a questionairre.

    1) Mothers Maiden Name
    2) Favorite Animal
    3) ____________
    4) etc.

    Can anyone help me with this please?

  2. #2
    Valued Forum Contributor tlafferty's Avatar
    Join Date
    04-08-2011
    Location
    United States, Tacoma, WA
    MS-Off Ver
    Excel 2010, Excel 2013 Customer Preview
    Posts
    1,112

    Re: New spreadsheet for each cell (list) with references

    I need a bit more information first:
    1) Will the new sheet be in the original workbook or will it be in a new workbook?
    2) Should the information "referrenced" in the original workbook be linked or just copied over?
    If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
    Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...

    Thomas Lafferty
    Analyst/Programmer

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: New spreadsheet for each cell (list) with references

    I doubt very much if you need separate sheets or a macro. Attach an example workbook
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Registered User
    Join Date
    08-31-2011
    Location
    Boston, MA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: New spreadsheet for each cell (list) with references

    tlefferty:

    Thank you for responding. The new sheet can be in the same workbook. AND the information (name, bday, and customer num) can be copied over.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1