+ Reply to Thread
Results 1 to 2 of 2

Help with a Formula or Macro

  1. #1
    Registered User
    Join Date
    12-26-2013
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2013
    Posts
    1

    Help with a Formula or Macro

    Good evening all, I am a brand new user to the forum. I am working on creating a spreadsheet for a friend to track kids he has sign up for a soccer league. I have created a main sheet that will be a master list of all kids. I have created additional sheets for grouping kids into the following age groups 3-4, 5-6, 7-8, 9-10, 11-12 and 13-14. I am looking for guidance on how to pull information from the main sheet and autopopulate it to the corresponding sheet based on the column for Birth Date. I had envisioned having a cell on the main page that you could put the current date and it would work backward from there to determine age. I would also like to be able to sort by color on the subpages so that you can identify kids that were born in each quarter of the year. Jan - March = Red, April - June = Orange, July - September = Yellow and October - December = Green. I am very much so a rookie in this area, so any help that you can provide in steering me in the right direction will be greatly appreciated. Thanks very much.

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

    Re: Help with a Formula or Macro

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    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]

+ 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. VBA Macro: Plugging an Array-Formula into a Cell and Dragging Formula Down Columns
    By Brianandstewie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-20-2013, 02:57 PM
  2. Replies: 1
    Last Post: 01-27-2013, 11:05 AM
  3. Macro: Applying formula to multiple cells in excel (formula editing)
    By city in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-27-2012, 06:41 AM
  4. Formula/macro - Apply certain formula as per duplicate cells in column L
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-10-2011, 12:28 AM
  5. Formula expected end of statement error, typing formula into cell as part of VBA macro
    By DavidGMullins@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2006, 03:05 PM

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