Converting Data from Access to Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1333352%22%20slang%3D%22en-US%22%3EConverting%20Data%20from%20Access%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1333352%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20established%20Access%20database%20with%20information%20and%20reports%20that%20generate%20specific%20data%20and%20can%20print%20them%20in%20nicely%20formatted%20options.%20I%20am%20trying%20to%20transfer%20it%20all%20to%20Excel%20and%20do%20the%20same%20features.%20I%20want%20to%20change%20to%20Excel%20so%20that%20I%20can%20save%20the%20document%20in%20one%20drive%20and%20my%20peers%20can%20edit%20the%20document.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20successfully%20transferred%20the%20physical%20raw%20data%20to%20excel.%20My%20problem%20aligns%20with%20making%20excel%20use%20the%20data%20and%20generate%20reports%20based%20on%20a%20users%20que.%20I%20am%20guessing%20it%20has%20something%20to%20do%20with%20macros%20but%20need%20some%20assistance.%20I%20have%20attached%20two%20images%20of%20types%20of%20reports%20I%20am%20trying%20to%20create.%20Looking%20for%20help%20in%20how%20to%20make%20reports%20and%20format%20correctly%20or%20someone%20with%20a%20recommendation%20of%20a%20good%20support%20team.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1333352%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1335200%22%20slang%3D%22en-US%22%3ERe%3A%20Converting%20Data%20from%20Access%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1335200%22%20slang%3D%22en-US%22%3EThis%20is%20impossible%20to%20answer%20without%20information%20about%20the%20structure%20of%20your%20data%20I'm%20afraid.%20Can%20you%20perhaps%20upload%20an%20anonymized%20version%20of%20your%20file%3F%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have an established Access database with information and reports that generate specific data and can print them in nicely formatted options. I am trying to transfer it all to Excel and do the same features. I want to change to Excel so that I can save the document in one drive and my peers can edit the document. 

 

I have successfully transferred the physical raw data to excel. My problem aligns with making excel use the data and generate reports based on a users que. I am guessing it has something to do with macros but need some assistance. I have attached two images of types of reports I am trying to create. Looking for help in how to make reports and format correctly or someone with a recommendation of a good support team. 

1 Reply
Highlighted
This is impossible to answer without information about the structure of your data I'm afraid. Can you perhaps upload an anonymized version of your file?