+ Reply to Thread
Results 1 to 2 of 2

Excel 2010, trying to use CF related to 4 sheets, not working, will vba work?

  1. #1
    Forum Contributor
    Join Date
    08-22-2009
    Location
    Manitoba
    MS-Off Ver
    Office 2010
    Posts
    524

    Excel 2010, trying to use CF related to 4 sheets, not working, will vba work?

    It's always a struggle to word title properly! Here is my problem. I have a workbook with many sheets, but there are 3 cells on on each of four sheets (thus 3 cells x 4 sheets = 12)which are posing this problem. On a 5th sheet is a group of cells and check boxes. If A1 on sheet1 is checked (this selection is also mirrored on sheets2,3 and 4), then I have CF that hides this info on sheet5 using white. Then if I remove the check from sheet1(A1) and put it in sheet1(A2 or A3), then I want what's on sheet5 to display. This works well if tied only to sheet1, but it I try and tie in the other three sheets it just does not work, such as changing sheet3(A1) to A3! I got very close, but I also have cells on sheet 5 that are yellow if empty and it's this I cannot seem to hide! So, I thought I would record a macro and try that, and by using an "IF" statement got close, got the stuff on sheet5 to hide, but then I could not get it to unhide. I hope I explained my predicament clear enough and hope there is a fairly simple way of making this work. Thanks for reading this long winded problem!

  2. #2
    Forum Contributor
    Join Date
    08-22-2009
    Location
    Manitoba
    MS-Off Ver
    Office 2010
    Posts
    524

    Re: Excel 2010, trying to use CF related to 4 sheets, not working, will vba work?

    I figured it out! Use an if statement on sheet5 to check the value of cells A1 on the other four sheets. If true, put a value of 1 in the cell. Then, any deviation from cell A1 in any of the four sheets will change the sum on sheet5. Then I just need to CF that sum cell, anything other than four causes CF to trigger! I tried it and works great!

+ 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. Save Macro Related question in Excel 2010
    By Tescatlipoca in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-23-2014, 02:46 PM
  2. Working 2007 excel add-in wont work with excell 2010 version. Please help.
    By kraft_mk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2014, 08:53 PM
  3. Replies: 0
    Last Post: 12-18-2013, 07:59 PM
  4. Replies: 4
    Last Post: 04-13-2013, 06:19 AM
  5. Excel 2010 slow working with multiple sheets
    By jlax34 in forum Excel General
    Replies: 3
    Last Post: 07-06-2012, 11:41 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