+ Reply to Thread
Results 1 to 10 of 10

how to make multiple sheets based on info in main worksheet

  1. #1
    Registered User
    Join Date
    09-08-2012
    Location
    rome
    MS-Off Ver
    Excel 2007
    Posts
    5

    how to make multiple sheets based on info in main worksheet

    HELP , sorry have checked out as many threads as possible to try and work out what I need to do but have realised that as far as EXCEL goes I am completely iliterate ...sorry
    I need to do the following
    WE have one main excel sheet on the server that four of us update and save with new reservations , the data on this sheet is ordered by file reference

    ColA Col b Colc Cold Cole Colf Colg
    PLSA30505 Alvarez Laura 2 arg toselli miércoles, 25 de enero de 2012 domingo, 05 de febrero de 2012
    we would need to make various cross reference sheets that show for example only the reservations for the month of january ( enero ) , then sheet 2 those for February , and so on thru to december and that these sheets update everytime someone enters new data

    Is it possible ??

    Please help

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: how to make multiple sheets based on info in main worksheet

    Yes its possible. Why dont you upload a sample sheet with some dummy data?

    To Attach a File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    09-08-2012
    Location
    rome
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: how to make multiple sheets based on info in main worksheet

    OK have attached file
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: how to make multiple sheets based on info in main worksheet

    i suggest an pivot table.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  5. #5
    Registered User
    Join Date
    09-08-2012
    Location
    rome
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: how to make multiple sheets based on info in main worksheet

    Hi thanks for the quick rèply but not excatly what I need ( probably didnt explain myself well )
    I need to keep the Sheet 1 as the main sheet for entering the data in reference order (PLSA30507 for example ) then on the subsequent pages I need to open one page for January , one page ofr february thru till december ...when we feed in data on sheet one it should automatically update on the month sheet that the reservation corresponds to .... for example
    new reservation PLSA30699 alvarez 2 arg Miercoles 26 sept 2012 when this info is written on the sheet 1 on the sheet for sept the information should also be added ....
    do I make sense ...................

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: how to make multiple sheets based on info in main worksheet

    it can be done with VBA, I can't help you enough with that.

    maybe you can use a filter on sheet 1 to get your result.

  7. #7
    Registered User
    Join Date
    09-08-2012
    Location
    rome
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: how to make multiple sheets based on info in main worksheet

    thanks will keep looking

  8. #8
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: how to make multiple sheets based on info in main worksheet

    Maybe coulde told us that you crossposted this question.

    http://www.mrexcel.com/forum/excel-q...worksheet.html

  9. #9
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: how to make multiple sheets based on info in main worksheet

    Thanks oeldere

    Hello lunima, and welcome to the forum.

    Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

    Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. Expect cross-posts without a link to be closed. A message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

  10. #10
    Registered User
    Join Date
    09-08-2012
    Location
    rome
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: how to make multiple sheets based on info in main worksheet

    Sorry we didnt do it purposely ... we are based in Rome english is not our first language and my colleague was trying to help me solve this problem and she also signed on to a web site to look for the solution ...our apologies we didnt mean to break any rules ..we just didnt know that each one had posted a request for help

    sorry as I am writing from my house computer i cannot put link in until tomorrow from work because i dont know which forum she asked to

+ 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