•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to create a mirrored printable data from certain cells
Our take
Transitioning from blue-collar work to an office role can be challenging, especially when navigating tools like Excel. If you're looking to create a mirrored, printable version of specific customer information from your sales forms, you’re on the right track. By automating the population of certain cells, you can streamline access to vital data for the shop floor. Ideally, converting this information into a PDF format will enhance efficiency, allowing operators to focus on their tasks without sifting through multiple documents.
so I made the pivot from blue collar work to the office at my company. I’m not super familiar with excel and have just began using it.
there are excel forms that sales uses to fill out certain customer information that has to be accessed at a different time to provide information to the shop floor. I’m trying to figure out a way to make those certain cells auto populate in an easily accessible and printable form. a pdf would be preferred but I’m not sure if that is possible. the idea is to print the information to include it with the blueprints so that the operator doesn’t have to spend his/her time looking through and for the documents . if anyone can point me in the right direction I would appreciate it!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Mirroring a sheet to be read only?Hello, I have a rather important excel file at work to keep track of some things. I want to share one sheet of this file with others so they can reference the data when needed, but not have edit access. I tried password protecting it, but it is somewhat awkward with how often it needs to be updated. So I would like to mirror just one sheet of this file to another file. So that when the master file is updated, the mirrored file also updates with the changes. But at the same time, the mirrored file isn’t editable by users. I could share this mirrored file with others and not have to worry about someone editing or breaking the master file. Is there any way to smoothly do this? Or is there some other way of going about sharing this data I haven’t thought of. Edit: I am using the latest version of excel included with Office 365 submitted by /u/Worked-last-time [link] [comments]
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]
- Formatting question for automating data entryIm going to try to articulate what I need and if it’s possible to do inside excel. At my job I have to record the amount of patrons using our facilities. and specify what particular services are being used. at the end of each quarter. (3 month period) I must tally up all the numbers and provide a total for each aspect of our facility as well as the total overall. For example. 1st quarter numbers. 100 patrons used theatre. 250 patrons used Game room 450 patrons used computer lab so on and so forth. Now that you have the gist in your head. Imagine a spreadsheet where the first form is just a data entry sheet. it’s essentially just a box that never changes. You input the numbers for the week, and that data gets automatically moved to a different cell that has the total amount. so that at the end of the quarter I can easily see my total without having to backtrack or tediously add. if anyone has some insight on how I can do this Please reach out. If you have any questions about my wording or understanding exactly what I mean please also reach out. If you read all this I appreciate your time. submitted by /u/Beneficial-Yard-9006 [link] [comments]
- using MS forms with excelHello! I have a massive spreadsheet that I need to use for lots of reporting. I've tried to pare it down as much as possible for those who have to do the actual data entry, but they are still very overwhelmed by it (they really don't understand how to even use filters to narrow down the scope) and so the data coming out is not reliable. I've never used MS forms in conjunction with excel, but I'm thinking that if I create a form for them just to enter the basics, I would at least have correct data for my analysis piece. The only thing I'm concerned about is that there are updates to entries that need to be made (ie- someone earns an additional level of certification or they drop out of the program). Can this be accomplished with forms? Or am I barking up the wrong tree. I was hoping to get some advice before I start really teaching myself how to use MS forms (any suggestions for good tutorials would be great too). Thank you in advance! submitted by /u/bluellama314 [link] [comments]