Pulling Values off 1 Cell from Multiple Worksheets

%3CLINGO-SUB%20id%3D%22lingo-sub-3315429%22%20slang%3D%22en-US%22%3EPulling%20Values%20off%201%20Cell%20from%20Multiple%20Worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3315429%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20workbook%20that%20i%20have%2065%20Worksheets%20that%20are%20all%20the%20same%20with%20different%20calculated%20Values.%20Is%20there%20a%20fast%20way%20to%20pull%20all%20of%20the%20values%20into%20one%20table%3F%20Each%20line%20in%20a%20table%20being%20the%20value%20i%20request%20from%20the%20same%20cell%20in%20each%20work%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3315429%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a workbook that i have 65 Worksheets that are all the same with different calculated Values. Is there a fast way to pull all of the values into one table? Each line in a table being the value i request from the same cell in each work sheet.

0 Replies