Home

Excel Spreadsheet Extract Data

%3CLINGO-SUB%20id%3D%22lingo-sub-743104%22%20slang%3D%22en-US%22%3EExcel%20Spreadsheet%20Extract%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743104%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20basic%20spreadsheet%20to%20track%20symptoms%20of%20a%20very%20rare%20neurological%20disorder%20from%20day%20to%20day.%20I%20used%20conditional%20formatting%20to%20flag%20certain%20conditions%20and%20a%20simple%20%22x%22%20in%20the%20box%20to%20mark%20foods%20consumed%20on%20a%20daily%20basis.%20For%20this%20to%20be%20effective%2C%20I%20need%20to%20maintain%20a%20new%20spreadsheet%20every%20day%2C%20and%20on%20days%20that%20get%20flagged%20based%20on%20symptoms%2C%20access%20marked%20data%20from%20the%20two%20previous%20days%20to%20look%20for%20any%20consistencies.%20Question%20is%2C%20how%20do%20I%20maintain%20these%20daily%20records%20without%20creating%20365%20tabs%20in%20my%20spreadsheet%3F%20Any%20best%20practices%20I%20can%20or%20should%20consider%3F%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-743104%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-743211%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Spreadsheet%20Extract%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743211%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F372862%22%20target%3D%22_blank%22%3E%40rschumaker%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20not%20you%20keep%20them%20all%20in%20one%20table%20in%20one%20sheet%3F%3C%2FP%3E%3CP%3EInstead%20of%20making%20a%20sheet%20for%20each%20day%2C%20make%20a%20sheet%20for%20each%20year.%3C%2FP%3E%3CP%3EYou%20can%20reference%20the%20day%20in%20the%20table%20by%20adding%20a%20column%20for%20it%20in%20the%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20460px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F122597i11C714DE20C6349F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screenshot_2.png%22%20title%3D%22Screenshot_2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-743379%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Spreadsheet%20Extract%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743379%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20has%20to%20work%20with%20this%3C%2FP%3E%3C%2FLINGO-BODY%3E
rschumaker
New Contributor

I have created a basic spreadsheet to track symptoms of a very rare neurological disorder from day to day. I used conditional formatting to flag certain conditions and a simple "x" in the box to mark foods consumed on a daily basis. For this to be effective, I need to maintain a new spreadsheet every day, and on days that get flagged based on symptoms, access marked data from the two previous days to look for any consistencies. Question is, how do I maintain these daily records without creating 365 tabs in my spreadsheet? Any best practices I can or should consider? Thanks

2 Replies

@rschumaker

 

Hi,

 

Why not you keep them all in one table in one sheet?

Instead of making a sheet for each day, make a sheet for each year.

You can reference the day in the table by adding a column for it in the table.

 

Screenshot_2.png

@Haytham Amairah 

It has to work with this