+ Reply to Thread
Results 1 to 2 of 2

Formula for Visible Cells with Target Cell Reference conflict

  1. #1
    Registered User
    Join Date
    08-16-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    2

    Formula for Visible Cells with Target Cell Reference conflict

    Greetings Everybody.


    Been dealing with an issue, hoping you all could guide me in the right direction. I’ve included an excerpt of my workbook. My workbook automatically pulls data for 18 days from other workbooks into separate work sheets. What I’m trying to do is have one worksheet (INPUT) compile all of these “Day” worksheets and have them filtered by date. I’ve written all the formulas out, but my issue is the actual pull of data. I’ll explain my process: (DAY1 is source, INPUT is target)

    1. Enter “=Day1!A2” into A2 of INPUT worksheet.
    2. Highlight full range of Column A (A2:A17585)
    3. ALT ; to highlight only visible cells
    4. CTRL D to auto fill.

    The issue that I’m getting is that, while the non-visible cells aren’t getting filled with this formula, the visible cells are still using the target cell reference in applying the formula (A2=Day1!G2, A20=Day1!19). What I would like to do is be able to filter INPUT by the date and autofill the formula so that A2=Day1!G2, A20=Day1!G3, A38=Day1!G4, etc. etc. and repeat this for each day.

    Fairly novice, and having trouble thinking on this right now.Example.xls So appreciate any help! Thank you and apologies for any misuse of excel language.

    Thank you,

    Dan

  2. #2
    Registered User
    Join Date
    08-16-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Formula for Visible Cells with Target Cell Reference conflict

    Bump for no response. Any ideas out there?

    Thank you,

    Dan

+ 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