New to Excel formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2057476%22%20slang%3D%22en-US%22%3ENew%20to%20Excel%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2057476%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20the%20proper%20formula%20for%20taking%20data%20from%20several%20cells%20on%20one%20sheet%20and%20moving%20them%20to%20a%20different%20sheet%20to%20be%20used%20on%20a%20chart%2C%20any%20help%20would%20be%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2057476%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-2057515%22%20slang%3D%22en-US%22%3ERe%3A%20New%20to%20Excel%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2057515%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F927951%22%20target%3D%22_blank%22%3E%40MikeP1978%3C%2FA%3E%26nbsp%3BThat's%20a%20very%20broad%20question.%20Formulae%20can't%20%3CSTRONG%3Emove%3C%2FSTRONG%3E%20data%20but%20you%20can%20%3CSTRONG%3Elink%3C%2FSTRONG%3E%20data%20in%20one%20sheet%20to%20another.%20Can%20you%20be%20a%20bit%20more%20specific%20and%20perhaps%20upload%20your%20workbook%20(replace%20any%20confidential%20information%20with%20something%20else).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2057555%22%20slang%3D%22en-US%22%3ERe%3A%20New%20to%20Excel%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2057555%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F927951%22%20target%3D%22_blank%22%3E%40MikeP1978%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%20I%20cannot%20upload%20the%20work%20book%2C%20but%3C%2FP%3E%3CTABLE%20width%3D%22627%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2263%22%3E%3CP%3E12.5%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2263%22%3E%3CP%3E20.0%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2263%22%3E%3CP%3E30.0%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2263%22%3E%3CP%3E40.0%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2263%22%3E%3CP%3E50.0%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2263%22%3E%3CP%3E60.0%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2263%22%3E%3CP%3E70.0%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2263%22%3E%3CP%3E80.0%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2263%22%3E%3CP%3E90.0%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2263%22%3E%3CP%3E100.0%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EIf%20I%20wanted%20to%20take%20this%20data%20from%20sheet%201%20(manually%20input)%20and%20transfer%20it%20to%20populate%20the%20data%20for%20this%20chart%20on%20sheet%202%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22640%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%3E%3CP%3E28.0%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%3CP%3E34.0%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%3CP%3E42.0%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%3CP%3E52.0%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%3CP%3E62.0%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%3CP%3E74.0%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%3CP%3E84.0%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%3CP%3E93.0%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%3CP%3E100.0%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%3CP%3E115.0%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MikeP1978_0-1610558330209.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F246159i66E36C83BB76E960%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22MikeP1978_0-1610558330209.png%22%20alt%3D%22MikeP1978_0-1610558330209.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2057609%22%20slang%3D%22en-US%22%3ERe%3A%20New%20to%20Excel%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2057609%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F927951%22%20target%3D%22_blank%22%3E%40MikeP1978%3C%2FA%3E%26nbsp%3BStill%20not%20very%20clear.%20Sorry!%3C%2FP%3E%3CP%3EBut%20perhaps%20like%20int%20eh%20attached%20workbook%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I need the proper formula for taking data from several cells on one sheet and moving them to a different sheet to be used on a chart, any help would be appreciated.

8 Replies

@MikeP1978 That's a very broad question. Formulae can't move data but you can link data in one sheet to another. Can you be a bit more specific and perhaps upload your workbook (replace any confidential information with something else).

@MikeP1978 

Unfortunately I cannot upload the work book, but

12.5

20.0

30.0

40.0

50.0

60.0

70.0

80.0

90.0

100.0

If I wanted to take this data from sheet 1 (manually input) and transfer it to populate the data for this chart on sheet 2

 

28.0

34.0

42.0

52.0

62.0

74.0

84.0

93.0

100.0

115.0

 

 

MikeP1978_0-1610558330209.png

 

 

@MikeP1978 Still not very clear. Sorry!

But perhaps like int eh attached workbook?

 

@Riny_van_Eekelen 

Perfect, sh1  A1:J1 = sh2 A1:J1 where sh1 is manually  input.

@MikeP1978 , it's not necessary to upload your actual workbook, you may generate the sample one with data exactly as in your post and desired result. It's worth to mention on which version of Excel you are. Hope @Riny_van_Eekelen make a correct guess, but with above chances to receive correct answer much higher. And faster.

@MikeP1978  I got it figured out, thank you guys for trying.  The formula I was looking for was =('sheet#'!cell#) will import info from one cell on one sheet to another.

@MikeP1978 , okay, thanks for the update. Just in case, if that range is needed only for Chart it's not necessary to copy it into Sheet2, you may take data within Chart directly form Sheet1

@Sergei Baklan That is good to know, I'm not sure that it will be good for my current needs but definitely will work on it today to get a better understanding.  Thank you.