Huskie
Elite
- Joined
- Nov 22, 2005
- Posts
- 2,556
- Location
- Brazil
- Society
- Apocalyptic Uprising
- Avatar Name
- John Huskie Hunt
Are you copying the columns themselves?
Try making a template worksheet with all the formulas and everything hidden appropriately, but with no data. Then when you get round to entering data, copy the template to a new sheet (right-click on the worksheet tab, I think the menu has a 'Move or Copy' option from which you can create a new copy of the sheet, which I imagine would have the columns hidden).
Yes, I was copying the columns themselves.
I'm currently trying the thing you mentioned but since the calculations refer to cells that are to the left of the actual calculation, the empty worksheet template either get's !REF errors if I place only the parts and formulas I need copied for new datasets to the main sheet, or I have to leave blank space to their left to the cells it references to, so there's no such reference errors, but then if I try to copy them over to the main sheet, the blank space will be copied over as well and need removal, too, which in the end is just as much of a hassle as hiding the columns over and over again.
Edit: the separate worksheet thing doesn't seem to work at all, unfortunately. It's a simple copy & paste just as if you had done it from the same sheet.
Last edited: