Home

Building a Monthly Report from Spreadsheets

%3CLINGO-SUB%20id%3D%22lingo-sub-314726%22%20slang%3D%22en-US%22%3EBuilding%20a%20Monthly%20Report%20from%20Spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314726%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20attempting%20to%20auto-generate%201%20main%2C%20monthly%20report%20(spreadsheet)%20with%20data%20that%20is%20collected%20at%203%20different%20satellite%20sites.%26nbsp%3B%20The%20majority%20of%20the%20data%20will%20come%20from%203%20spreadsheets%20that%20are%20received%20each%20month.%26nbsp%3B%20Each%20of%20the%203%20reports%20has%20the%20same%20format%2C%20but%20the%20values%20may%20be%20different.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrently%2C%20there%20is%20a%20lot%20of%20copying%20and%20pasting%20or%20re-typing%20of%20the%20same%20information.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20must%20be%20an%20easier%20way%20to%20get%20the%20values%20from%20the%203%20reports%2C%20total%20them%20and%20insert%20that%20value%20to%20the%20main%20report.%26nbsp%3B%20Any%20help%20would%20be%20most%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-314726%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314775%22%20slang%3D%22en-US%22%3ERe%3A%20Building%20a%20Monthly%20Report%20from%20Spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314775%22%20slang%3D%22en-US%22%3ETry%20to%20attach%20the%20reports%20you%20want%20to%20get%20information%20from%20and%20the%20spreadsheet%20you%20want%20to%20be%20filled%20with%20their%20data.%3CBR%20%2F%3EJust%20remove%20the%20unnecessary%2Fconfidential%20data%20from%20it.%3C%2FLINGO-BODY%3E
AHA_Sanders
Occasional Visitor

I am attempting to auto-generate 1 main, monthly report (spreadsheet) with data that is collected at 3 different satellite sites.  The majority of the data will come from 3 spreadsheets that are received each month.  Each of the 3 reports has the same format, but the values may be different.  

 

Currently, there is a lot of copying and pasting or re-typing of the same information.

 

There must be an easier way to get the values from the 3 reports, total them and insert that value to the main report.  Any help would be most appreciated.

1 Reply
Try to attach the reports you want to get information from and the spreadsheet you want to be filled with their data.
Just remove the unnecessary/confidential data from it.
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
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies