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
Report for Videoconferencing quality
Thomas_Steibl in Microsoft Teams on
3 Replies
Azure Reporting
Christian Taveras in Azure on
1 Replies
New Microsoft Edge updates even in limited connections
vctgomes in Discussions on
3 Replies
Exporting Meeting Call History to CSV/Excel
craig taylor in Microsoft Teams on
3 Replies
Excel not working
Claud88 in Excel on
1 Replies