Home

Blank workbook when first opened until key dates are entered.

%3CLINGO-SUB%20id%3D%22lingo-sub-583605%22%20slang%3D%22en-US%22%3EBlank%20workbook%20when%20first%20opened%20until%20key%20dates%20are%20entered.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-583605%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EIn%20the%20attached%20workbook%2C%20I%20would%20like%20the%20three%20colored%20tables%20to%20be%20blank%20when%20opening%20until%20a%20couple%20of%20dates%20are%20entered.%3C%2FP%3E%3CP%3EOnce%20Cell%20B6%20is%20a%20manually%20entered%2C%20Cell%20A19%20%3D%20that%20date.%20Then%20the%20rest%20of%20that%20row%20will%20automatically%20populate.%3C%2FP%3E%3CP%3EThen%20when%20Cell%20B7%20is%20manually%20entered%20the%20rest%20of%20the%20rows%20fill%20in%20up%20to%20that%20date.%3C%2FP%3E%3CP%3EWhen%20additional%20months%20are%20needed%2C%20it%20will%20automatically%20pull%20the%20last%20needed%20month%20from%20Cell%20B45%E2%80%99s%20value%20and%20add%20the%20info%20to%20the%20gray%20table.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-583605%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-583640%22%20slang%3D%22en-US%22%3ERe%3A%20Blank%20workbook%20when%20first%20opened%20until%20key%20dates%20are%20entered.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-583640%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F339153%22%20target%3D%22_blank%22%3E%40drt_80%3C%2FA%3E%26nbsp%3BMaybe%20I%20am%20not%20understanding%20your%20problem%20properly%20but%20why%20can't%20you%20use%20and%20IF%20statement%20in%20the%20cells%20that%20you%20want%20blank%20until%20date%20is%20entered%20in%20B6%20%26amp%3B%20B7%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-615113%22%20slang%3D%22en-US%22%3ERe%3A%20Blank%20workbook%20when%20first%20opened%20until%20key%20dates%20are%20entered.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-615113%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20creating%20this%20for%20other%20people%20to%20use.%20I%20am%20wanting%20it%20to%20be%20as%20simple%20as%20possible%20for%20them%20to%20use.%20The%20only%20cells%20I%20want%20them%20in%20is%20A1%3AB12%20and%20columns%20J%2CK%2C%26amp%3B%20L.%20I%20am%20fairly%20new%20to%20excel%2C%20therefore%20i%20am%20not%20sure%20of%20the%20correct%20formulas%20to%20use%20to%20achieve%20what%20i%20am%20wanting.%20Thanks.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F335273%22%20target%3D%22_blank%22%3E%40gs_aujla%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
drt_80
Occasional Contributor

Hello,

In the attached workbook, I would like the three colored tables to be blank when opening until a couple of dates are entered.

Once Cell B6 is a manually entered, Cell A19 = that date. Then the rest of that row will automatically populate.

Then when Cell B7 is manually entered the rest of the rows fill in up to that date.

When additional months are needed, it will automatically pull the last needed month from Cell B45’s value and add the info to the gray table.

2 Replies

@drt_80 Maybe I am not understanding your problem properly but why can't you use and IF statement in the cells that you want blank until date is entered in B6 & B7?

I am creating this for other people to use. I am wanting it to be as simple as possible for them to use. The only cells I want them in is A1:B12 and columns J,K,& L. I am fairly new to excel, therefore i am not sure of the correct formulas to use to achieve what i am wanting. Thanks. @gs_aujla 

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies