SOLVED

automatic entry of data from a cell on one worksheet to different cell on another worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1617562%22%20slang%3D%22en-US%22%3Eautomatic%20entry%20of%20data%20from%20a%20cell%20on%20one%20worksheet%20to%20different%20cell%20on%20another%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1617562%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%26nbsp%3B%20I%20have%20a%20number%20of%20worksheets%20in%20one%20workbook%20that%20serve%20different%20purposes%20but%20uses%20a%20lot%20of%20the%20same%20information.%26nbsp%3B%20How%20can%20I%20programme%20excel%20to%20duplicate%20information%20in%20a%20cell%20on%20sheet%201%20to%20a%20selected%20cell%20on%20sheet%202%20and%20sheet%203%3F%26nbsp%3B%20I%20do%20not%20want%20to%20keep%20copying%20and%20pasting.%26nbsp%3B%20I%20know%20how%20to%20insert%20information%20on%20sheet%201%20to%20the%20same%20cell%20on%20sheet%202%20but%20not%20to%20a%20different%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1617562%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1617576%22%20slang%3D%22en-US%22%3ERe%3A%20automatic%20entry%20of%20data%20from%20a%20cell%20on%20one%20worksheet%20to%20different%20cell%20on%20another%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1617576%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F773925%22%20target%3D%22_blank%22%3E%40Roz_Baldie66%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%20I%20hope%20I%20can%20help%20you%3C%2FP%3E%3CP%3E%3DSheet1!A2%20this%20formula%20replicates%20what%20is%20written%20in%20A2%20from%20Sheet1%3C%2FP%3E%3CP%3EIt%20means%20that%20you%20can%20use%20a%20formula%20on%20your%20worksheets%20to%20refer%20a%20value%20of%20a%20lets%20say%20%22main%20worksheet%22.%3C%2FP%3E%3CP%3ESometime%20it%20is%20boring%20to%20do%20it%20manually%20in%20each%20worksheet%2C%20but%20if%20you%20select%20more%20than%201%20worksheet%20and%20type%20a%20formula%2C%20this%20formula%20will%20also%20be%20replicated%20to%20all%20selected%20worksheets%20saving%20a%20lot%20of%20your%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1618069%22%20slang%3D%22en-US%22%3ERe%3A%20automatic%20entry%20of%20data%20from%20a%20cell%20on%20one%20worksheet%20to%20different%20cell%20on%20another%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1618069%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767933%22%20target%3D%22_blank%22%3E%40Juliano-Petrukio%3C%2FA%3E%26nbsp%3BHi%20there%2C%20thank%20you%20for%20your%20quick%20response.%26nbsp%3B%20The%20issue%20I%20have%20is%20duplicating%20from%20Sheet1!A2%26nbsp%3Bto%20Sheet2!B3%20and%20to%20Sheet3!D7%3C%2FP%3E%3CP%3EI%20want%20to%20be%20able%20to%20type%20information%20onto%20one%20sheet%20and%20for%20it%20to%20be%20duplicated%20onto%20other%20sheets%20but%20specific%20cell%20locations%20not%20the%20same%20location.%3C%2FP%3E%3CP%3EI%20hope%20this%20makes%20sense.%3C%2FP%3E%3CP%3ECan%20you%20help%3F%3C%2FP%3E%3CP%3Eregards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1618300%22%20slang%3D%22en-US%22%3ERe%3A%20automatic%20entry%20of%20data%20from%20a%20cell%20on%20one%20worksheet%20to%20different%20cell%20on%20another%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1618300%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F773925%22%20target%3D%22_blank%22%3E%40Roz_Baldie66%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheck%20if%20the%20sample%20worksheet%20attached%20is%20what%20you%20are%20looking%20for.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1618367%22%20slang%3D%22en-US%22%3ERe%3A%20automatic%20entry%20of%20data%20from%20a%20cell%20on%20one%20worksheet%20to%20different%20cell%20on%20another%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1618367%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767933%22%20target%3D%22_blank%22%3E%40Juliano-Petrukio%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3Ethat%20is%20exactly%20what%20I%20am%20looking%20for.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1618713%22%20slang%3D%22en-US%22%3ERe%3A%20automatic%20entry%20of%20data%20from%20a%20cell%20on%20one%20worksheet%20to%20different%20cell%20on%20another%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1618713%22%20slang%3D%22en-US%22%3EThat%20is%20so%20good%20to%20hear%20from%20you.%3CBR%20%2F%3EPlease%20don't%20forget%20to%20mark%20as%20Official%2FBest%20Answer%20to%20help%20the%20other%20members%20find%20it%20too.%20If%20you%20think%20I%20deserve%20a%20like%20for%20this%20answer%2C%20hit%20the%20like%20button.%3CBR%20%2F%3EThank%20you%3C%2FLINGO-BODY%3E
New Contributor

Hi there,  I have a number of worksheets in one workbook that serve different purposes but uses a lot of the same information.  How can I programme excel to duplicate information in a cell on sheet 1 to a selected cell on sheet 2 and sheet 3?  I do not want to keep copying and pasting.  I know how to insert information on sheet 1 to the same cell on sheet 2 but not to a different cell.

5 Replies

@Roz_Baldie66 

Hello I hope I can help you

=Sheet1!A2 this formula replicates what is written in A2 from Sheet1

It means that you can use a formula on your worksheets to refer a value of a lets say "main worksheet".

Sometime it is boring to do it manually in each worksheet, but if you select more than 1 worksheet and type a formula, this formula will also be replicated to all selected worksheets saving a lot of your time.

 

@Juliano-Petrukio Hi there, thank you for your quick response.  The issue I have is duplicating from Sheet1!A2 to Sheet2!B3 and to Sheet3!D7

I want to be able to type information onto one sheet and for it to be duplicated onto other sheets but specific cell locations not the same location.

I hope this makes sense.

Can you help?

regards

 

Best Response confirmed by cuong (Microsoft)
Solution

@Roz_Baldie66 

Check if the sample worksheet attached is what you are looking for.

That is so good to hear from you.
Please don't forget to mark as Official/Best Answer to help the other members find it too. If you think I deserve a like for this answer, hit the like button.
Thank you