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
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies