Forum Discussion
Making a Report
Hello,
I am extremely new to Excel. I have stepped into a new position within my company. My trainer/predecessor is old school and does a lot of paperwork physically or manually enters data into excel. I know there is a way to make a blank report form that when product information is entered, it populates the required information needed.
Someone provided the solution to 2 pieces of relevant information in another thread and I thought I could do the rest, but I was unable to make the formulas to populate.
1 Reply
I'm not following all the statistics you want to calculate but believe your approach with long formulas is both error prone and difficult to maintain. Why not use some pivot tables in stead. I've added a sheet ("PT") to your file and hope it will trigger some ideas.
