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
Bookmarks