Home

Problems populating my reports worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-793569%22%20slang%3D%22en-US%22%3EProblems%20populating%20my%20reports%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-793569%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20workbook%20with%20three%20Report%20worksheets%20and%20a%20Data%20Collection%20worksheet.%20The%20Report%20worksheet%20with%20the%20problem%20is%20in%20Page%20layout%208.5x11%20with%20headers%20and%20footers%20with%20the%201st%20row%20repeating.%20The%20footer%20is%20for%20page%20%23%2C%20and%20is%20setup%20for%20Right%20then%20Down%20The%20first%20Row%20is%201%20thru%2010%20pages%20The%20second%20row%20is%20pages%2011%20thru%2020%20ect..%20In%20the%20past%20I%20have%20been%20able%20to%20Copy%20the%20needed%20data%20from%20the%20data%20collection%20sheet%20and%20paste%20it%20into%20the%20report%20in%20to%20A2%20on%20the%20first%20page.%20The%20problem%20is%20the%20data%20goes%20down%20not%20to%20the%20right.%20Any%20help%20I%20can%20get%20will%20help%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-793569%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
HapSaunders
Frequent Visitor

I have workbook with three Report worksheets and a Data Collection worksheet. The Report worksheet with the problem is in Page layout 8.5x11 with headers and footers with the 1st row repeating. The footer is for page #, and is setup for Right then Down The first Row is 1 thru 10 pages The second row is pages 11 thru 20 ect.. In the past I have been able to Copy the needed data from the data collection sheet and paste it into the report in to A2 on the first page. The problem is the data goes down not to the right. Any help I can get will help Thanks

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies