Worksheets & Percentages

%3CLINGO-SUB%20id%3D%22lingo-sub-2593264%22%20slang%3D%22en-US%22%3EWorksheets%20%26amp%3B%20Percentages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2593264%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%26nbsp%3B%20Is%20there%20a%20way%20to%20take%20a%20percentage%20of%20rows%20%2Fcolumns%20from%20a%20different%20worksheet%20than%20what%20the%20percentage%20chart%20is%20on%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELike%20some%20type%20of%20formula%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2593264%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello!  Is there a way to take a percentage of rows /columns from a different worksheet than what the percentage chart is on?

 

Like some type of formula?

 

1 Reply

@TSilk 

Many roads lead to Rome, more roads lead to a solution in Excel :).


In this link you can find some suggestions:
Move or copy cells and cell contents

Use Cut, Copy, and Paste to move or copy cell contents. Or copy specific contents or attributes from the cells. For example, copy the resulting value of a formula without copying the formula, or copy only the formula.

When you move or copy a cell, Excel moves or copies the cell, including formulas and their resulting values, cell formats, and comments.

You can move cells in Excel by drag and dropping or using the Cut and Paste commands.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.