+ Reply to Thread
Results 1 to 5 of 5

Creating populated forms from a spreadsheet

  1. #1
    Registered User
    Join Date
    09-18-2008
    Location
    London
    Posts
    3

    Creating populated forms from a spreadsheet

    I've created a staff roster for a 365 period and it would be helpful if I could create a seperate form for each day showing who's working on that day. I don't have time to link 365 forms. Is there a quicker way?

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    Hi and welcome to the board.
    Could you post a sample of your staff roster and an example of what you want ?
    Do you want on sheet a day ?

    Cheers

  3. #3
    Registered User
    Join Date
    09-18-2008
    Location
    London
    Posts
    3
    Ok the spreadsheet is quite basic but contains a large amount of data. What I want to do is for staff to be able to look at a sheet and see who's working on that particular day. So the sheet just needs a list of staff who are working, their role and manager etc. This info is included in the spreadsheet.

    The spreadsheet has columns with 365 individual dates on and rows of names. Then a Y in a cell if they're working that day.
    Last edited by antony-ryan; 09-18-2008 at 03:56 AM.

  4. #4
    Registered User
    Join Date
    09-18-2008
    Location
    London
    Posts
    3
    I do want a sheet for each day.

  5. #5
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    No sheet attached.
    Upload via the " manage attachments" button un the thread reply page

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help in creating an Excel spreadsheet for golf handicap calculation
    By bubuy12 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 08-24-2022, 12:28 AM
  2. creating numbered purchase order forms
    By tekneck in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-11-2008, 04:05 AM
  3. Resolved >>> Creating new sht from template sht & filling in summary sht - userform
    By lou031205 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-23-2007, 04:10 PM
  4. Deleting Frontpage forms from Excel spreadsheet
    By drew.glaser in forum Excel General
    Replies: 1
    Last Post: 08-13-2007, 05:01 PM
  5. Creating a work load spreadsheet
    By Warren in forum Excel General
    Replies: 2
    Last Post: 09-20-2006, 08:04 AM

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