I have a workbook that i would like to link the first sheet as an "index" to other sheets via a due date
I have a workbook that i would like to link the first sheet as an "index" to other sheets via a due date
Last edited by troyc; 01-14-2015 at 05:23 PM.
Hi, welcome to the forum
I dont have 2013, but I believe that from 2010 onwards, you can use CF across sheets, just the same as within the same sheet
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
What does that mean exactly? How about a little more detail?I have a workbook that i would like to link the first sheet as an "index" to other sheets via a due date
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
i am trying to create a maintenance database and want my index page to show if there is a service due on a particular day
i am trying to explain this the best i can
i need the cell on to have a formula that looks at all the dates in a range of cells and if date is the same as todays date to show up as colour
i hope this makes more sense
If you are familiar with Conditional Formatting, you should be able to use CF across sheets.
If you are not familiar with CF, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
Thanks for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks