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
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
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
Pulling data from one tab to another
krysphares in Excel on
6 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
Set Default to Copy and Paste Visible Cells Only
Karen Arigo in Excel on
2 Replies
How often the sync is triggered?
HotCakeX in Discussions on
5 Replies