•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Exporting just one sheet?
Our take
Exporting a single sheet from a multi-sheet spreadsheet can streamline your workflow, especially when preparing data for customers. If you're looking to create a new Excel document from your "customer" sheet, it is indeed possible to export both values and formulas. You can hard-code specific values as static numbers while retaining the formulas that perform calculations on the same sheet. This approach allows you to maintain the integrity of your data while simplifying the export process.
Looking for a clean way to do this. I've got a spreadsheet with multiple sheets that refence eachother for preparing data for a customer. Obviously I can just print one sheet but what I would really like to do is export the "customer" sheet as a new excel document. Ideally with some of the values becoming their data on the new sheet, but other cells keeping their formulas
Example, first box would be what the cells on the export sheet output, next being their formulas.
the second set would be how I would like to export, Hard coding the values as regular numbers that are referenced from a different sheet, but keeping the formulas that do math on the same sheet.
Is this possible?
| =DifferentSheet!P7 | =A1*10 |
|---|---|
| =DifferentSheet!P8 | =A2*10 |
| =DifferentSheet!P9 | =A3*10 |
| 11.5 | =A1*10 |
|---|---|
| 12 | =A2*10 |
| 14 | =A3*10 |
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Hot folder data sorting.My goal is to create a hot folder that I am able to continuously drop data sheets into. Then have excel transfer a few specific cells ie.( totals, names )into a uniform row on a new table/sheet. •all data sheets will be formatted the exact same and information will be in the same positions across all of them •data sheets will be added daily •each data sheet needs to create its own respective line representing information from only that sheet •some of the cells needed are a result of total formulas in the data sheet •no information besides the specific cells should reflect in the new table (Photos in comments) P1- example of the data sheets used with the cells circled that are wanted to be transferred. P2- example of what it should somewhat look like when presented in the table/sheet submitted by /u/Notsuspicious444 [link] [comments]
- join content from cells in a column without losing content from the corresponding columns.basically how do i make the highlighted screenshot look like the unhighlighted one but with a function for a spreadsheet with like 170k rows. sorry that this is in sheets. im trying to figure out if what i need is to buy excel basically what i want is to condense duplicative info while listing/joining the different pieces, all controlled for case number. https://preview.redd.it/4rfjrucnjdzg1.png?width=1408&format=png&auto=webp&s=ff424cf0a8553fe30b769986169901c1ca25a3bd https://preview.redd.it/c8mtq58ojdzg1.png?width=1080&format=png&auto=webp&s=21ccbdfd8ae8d41eb2d69368e62163df3737088b submitted by /u/Abi-Ankeney-PMM [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]
- Central Data Sheet efficiencyHoping that someone with some in depth technical knowledge of Excel can help me out with a query. We issue Finance Tracker spreadsheets to projects in our organisation, and then link them back to a central sheet that we use for monitoring and reporting. There are maybe 40-50 cells in each spreadsheet that we need to pull in to our central sheet, but they’re spread around the tracker and so are generally linked individually, and we’re now approaching 120 trackers that need to be linked, so the central sheet is starting to get quite slow to load and update. My question is this: When doing cross workbook cell look ups, do arrays work more efficiently than individual cell references, or is there no noticeable difference in runtime? My idea is to, in each project’s workbook, create an “export” tab that contains all the information that needs to be pulled out, and link the central sheet by looking at that array, rather than each individual cell. submitted by /u/Jamespg614 [link] [comments]