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
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
Highlighted

@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?

Highlighted

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