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

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
Date filtering of Bing Searches
PhilipE3 in Discussions on
2 Replies
Setting Date in Stored Procedure
Tim Hunter in SQL Server on
1 Replies
Share cell data between workbooks
gcooke75 in Excel on
3 Replies
Vision Keynote - Satya Nadella
Hubb.me in Microsoft Build Content on
1 Replies