Home

Data input on both a worksheet and a workbook at the same time

%3CLINGO-SUB%20id%3D%22lingo-sub-673712%22%20slang%3D%22en-US%22%3EData%20input%20on%20both%20a%20worksheet%20and%20a%20workbook%20at%20the%20same%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-673712%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20input%20data%20on%20both%20a%20work%20sheet%20and%20a%20work%20book%20at%20the%20same%20time.%26nbsp%3B%20How%20do%20I%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-673712%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-675781%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20input%20on%20both%20a%20worksheet%20and%20a%20workbook%20at%20the%20same%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-675781%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F355774%22%20target%3D%22_blank%22%3E%40Sec37%3C%2FA%3E%26nbsp%3Bhello%20there.%20The%20answer%20to%20your%20question%20is%20somewhat%20two-sided.%20A%20%3CSTRONG%3EWorkbook%3C%2FSTRONG%3E%20contains%20%3CSTRONG%3EWorksheets%3C%2FSTRONG%3E.%20You%20enter%20data%20onto%20%3CSTRONG%3EWorksheets%3C%2FSTRONG%3E%2C%20thus%20contained%20in%20its%20%3CSTRONG%3EWorkbook%3C%2FSTRONG%3E.%20This%20means%20you%20can't%20enter%20data%20into%20a%20%3CSTRONG%3EWorkbook%3C%2FSTRONG%3E%20but%20only%20a%20%3CSTRONG%3EWorksheet%3C%2FSTRONG%3E%2C%20which%20resides%20in%20a%20%3CSTRONG%3EWorkbook%3C%2FSTRONG%3E.%20Does%20that%20make%20sense%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Sec37
Occasional Visitor

I want to input data on both a work sheet and a work book at the same time.  How do I do this?

 

1 Reply

@Sec37 hello there. The answer to your question is somewhat two-sided. A Workbook contains Worksheets. You enter data onto Worksheets, thus contained in its Workbook. This means you can't enter data into a Workbook but only a Worksheet, which resides in a Workbook. Does that make sense? 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
12 Replies