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
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
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
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies