Home

Copying data from one worksheet to another within the same workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-532767%22%20slang%3D%22en-US%22%3ECopying%20data%20from%20one%20worksheet%20to%20another%20within%20the%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-532767%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20worksheets%20within%20the%20same%20workbook.%20One%20worksheet%20is%20just%20a%20summary%20of%20the%20other%2C%20and%20is%20used%20exclusively%20for%20printing.%20The%20other%20worksheet%20contains%20multiple%20formulas%2C%20but%20with%20a%20total%2C%20which%20is%20registered%20in%20column%20A%20in%20Worksheet%201.%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20worksheet%202%2C%20this%20data%20may%20appear%20in%20column%201%2C%20column%2010%2C%20or%20column%2020.%20How%20can%20If%20I%20do%20an%20equal%20for%20the%20first%20row%20at%20the%20top%20of%20each%20column%2C%20how%20can%20I%20make%20it%20increase%20the%20row%20number%20going%20down%20the%20column%2C%20so%20that%20the%20correct%20data%20is%20copied%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-532767%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-539078%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20data%20from%20one%20worksheet%20to%20another%20within%20the%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-539078%22%20slang%3D%22en-US%22%3EI%20can't%20understand%20what%20you%20mean.%20Please%20attach%20your%20sample%20file%20with%20manually%20entered%20results%2C%20which%20you%20want%20to%20be%20returned%20by%20formulas.%3C%2FLINGO-BODY%3E
Highlighted
Robert_1953
Occasional Visitor

I have two worksheets within the same workbook. One worksheet is just a summary of the other, and is used exclusively for printing. The other worksheet contains multiple formulas, but with a total, which is registered in column A in Worksheet 1. 

In worksheet 2, this data may appear in column 1, column 10, or column 20. How can If I do an equal for the first row at the top of each column, how can I make it increase the row number going down the column, so that the correct data is copied?

1 Reply
Highlighted
I can't understand what you mean. Please attach your sample file with manually entered results, which you want to be returned by formulas.
Related Conversations