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.
