•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Exporting just one sheet?
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]
Want to read more?
Check out the full article on the original site