Home

Copying information from one cell in one to another worksheet.

%3CLINGO-SUB%20id%3D%22lingo-sub-352115%22%20slang%3D%22en-US%22%3ECopying%20information%20from%20one%20cell%20in%20one%20to%20another%20worksheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352115%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20simple%20set%20up%20in%20excel%20where%20I%20use%20one%20tab%20for%20customer%20invoices%20and%20one%20tab%20for%20my%20costs.%26nbsp%3B%20I%20would%20like%20to%20be%20able%20to%20enter%20customer%20info%20in%20only%20one%20time%2C%20and%20have%20it%20populate%20the%20other%20customer%20info%20area%20in%20the%20opposite%20sheet.%26nbsp%3B%20Is%20that%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-352115%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Emoving%20data%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-352119%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20information%20from%20one%20cell%20in%20one%20to%20another%20worksheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352119%22%20slang%3D%22en-US%22%3E%3CP%3EYes.%20If%20you%20have%20each%20transaction%20as%20a%20row%20eg%3A%3CBR%20%2F%3EDate%7CCustomer%20name%7CInvoice%20Amount%7C%3CBR%20%2F%3EAnd%20your%20costs%20sheet%20might%20look%20like%3A%3CBR%20%2F%3E%7CDate%7CCustomer%20Info%7CMy%20Cost%7CSupplier%7CTax%7C%3CBR%20%2F%3EIn%20the%20costs%20sheet%2C%20click%20the%20first%20empty%20cell%20below%20the%20Customer%20Info%20heading%20and%20press%20the%20%3D%20key%2C%20switch%20back%20to%20the%20Invoices%20tab%20and%20click%20the%20cell%20you%20want%20to%20get%20the%20customer%20information%20from.%20Press%20enter.%20You%20have%20just%20linked%20a%20cell%20in%20your%20costs%20tab%20to%20the%20cell%20in%20the%20invoices%20tab.%3CBR%20%2F%3EClick%20the%20same%20cell%20in%20the%20My%20Costs%20tab%20again-%20there%20will%20be%20a%20little%20square%20in%20the%20bottom%20right%20corner.%20Drag%20that%20square%20down%20the%20column%20to%20the%20size%20you%20desire%20for%20the%20number%20of%20transactions-%20this%20will%20link%20the%20same%20cells%20on%20the%20Invoices%20tab%20so%20that%20when%20you%20enter%20information%20into%20them%2C%20the%20same%20info%20will%20appear%20in%20the%20My%20Costs%20tab.%20There%20are%20a%20number%20of%20ways%20to%20achieve%20the%20same%20thing-%20have%20a%20google%20for%20%22fill%20down%22%20(CTRL-D)%20and%20cell%20references.%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20might%20also%20be%20handy%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcreate-or-change-a-cell-reference-c7b8b95d-c594-4488-947e-c835903cebaa%23bmcreate_a_cell_reference_to_another_wo%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcreate-or-change-a-cell-reference-c7b8b95d-c594-4488-947e-c835903cebaa%23bmcreate_a_cell_reference_to_another_wo%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-352117%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20information%20from%20one%20cell%20in%20one%20to%20another%20worksheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352117%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20can%22t%20help%20you%20are%20in%20not%20enterprise%20account%20that%22s%20why%3C%2FP%3E%3C%2FLINGO-BODY%3E
Brooke115
Occasional Visitor

I have a simple set up in excel where I use one tab for customer invoices and one tab for my costs.  I would like to be able to enter customer info in only one time, and have it populate the other customer info area in the opposite sheet.  Is that possible?

2 Replies

i can"t help you are in not enterprise account that"s why

Yes. If you have each transaction as a row eg:
Date|Customer name|Invoice Amount|
And your costs sheet might look like:
|Date|Customer Info|My Cost|Supplier|Tax|
In the costs sheet, click the first empty cell below the Customer Info heading and press the = key, switch back to the Invoices tab and click the cell you want to get the customer information from. Press enter. You have just linked a cell in your costs tab to the cell in the invoices tab.
Click the same cell in the My Costs tab again- there will be a little square in the bottom right corner. Drag that square down the column to the size you desire for the number of transactions- this will link the same cells on the Invoices tab so that when you enter information into them, the same info will appear in the My Costs tab. There are a number of ways to achieve the same thing- have a google for "fill down" (CTRL-D) and cell references.

This might also be handy:
https://support.office.com/en-us/article/create-or-change-a-cell-reference-c7b8b95d-c594-4488-947e-c...


Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies