newbie here so be gentle .
Questions are as follows :-
1. I,m trying to see if excel can add a new sheet if say a tick box was ticked ,this sheet rather than being blank would need to be a template .
2. How do you make a tick box ?
3. The other issue I have is at the moment I have 2 sheets that I want to make into 1 , but if I did this the 1 sheet would be too long to make it user friendly . Is it possible again maybe with tick boxes to show or hide cells / columns so you only see the areas you want to work on etc .
4 . How do put the sheets tabs at top of page instead of at the bottom .
5. Last question bit difficult to explain but we make machined components which are assemblies consisting of parts , so is it possible to have a cell which is lets say my assembly that I,m quoting . But I want to be able to add or link parts to this as I'm quoting so it creates a structure . As we tend to quote the assembly first then only if we get the job then break it down into the parts for scheduling times etc , we would need ability to add the parts in. Ideally parts could be seen or hidden with +- button.
Last question bit difficult to explain so ignore if it is
thanks in advance for any answers to the questions
One issue per thread please, and only closely related follow-on questions in the same thread.
We'll pick an easy one - #4: You don't and you can't.
As a newbie bonus (and this time only):
#1 - Design your template and save it. Then Insert a new sheet based on that template. You can get the rest from your (to be posted) question on using Check boxes which can answer 2, 3 and the remaining part of this question...
#5 is a whole new question... But you need to bear in mind if it's hard to explain, it's even harder for someone unfamiliar with your process to suggest a solution. You need to ensure you explain exactly what is required.
There are currently 1 users browsing this thread. (0 members and 1 guests)