Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: Trying to automatically add a sheet & trying to make a cell hide or show other cells

  1. #1
    Join Date
    24th April 2013
    Posts
    2

    Trying to automatically add a sheet & trying to make a cell hide or show other cells

    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
    cheers chris

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    1st September 2010
    Posts
    7,907

    Re: Trying to automatically add a sheet & trying to make a cell hide or show other ce

    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.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 7
    Last Post: April 26th, 2011, 03:48
  2. Replies: 3
    Last Post: October 27th, 2008, 07:44
  3. Automatically Hide/Show Rows Across Worksheets
    By Frisbee Dog in forum EXCEL HELP
    Replies: 3
    Last Post: April 18th, 2008, 06:38
  4. Automatically Hide / Show Rows Based On Cell Value
    By bechardl in forum EXCEL HELP
    Replies: 3
    Last Post: February 27th, 2008, 21:10
  5. Hide & Show Sheets Automatically
    By Reafidy in forum EXCEL HELP
    Replies: 3
    Last Post: December 28th, 2006, 15:43

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno