+ Reply to Thread
Results 1 to 3 of 3

creating spreadsheets using a template and data sheet

  1. #1
    Registered User
    Join Date
    01-07-2014
    Location
    St. George's, Bermuda
    MS-Off Ver
    Excel 2010 and 13
    Posts
    2

    creating spreadsheets using a template and data sheet

    Good day all. I have a spreadsheet that I use for collecting dental records. I currently use Capturx for excel. we are looking to move to using tablets. the form currently works using the capturex function and a lot of modified codes.

    the main function is to clone the spreadsheet and prepopulate the worksheets with the data. the summary data is working and all of the functions are working. the main two issues I have right now is how to clone the spreadsheet with out call ing the adapx function and also the other problem is minor. as we were using paper and pen we wer able to just circle the teeth that were present. now I am curious how we will know which ones are present if we are using tablets. do tablets have the function for us to just circle a cell?

    thank you for your assistance.

    I can attach a sheet if that would help

  2. #2
    Registered User
    Join Date
    01-07-2014
    Location
    St. George's, Bermuda
    MS-Off Ver
    Excel 2010 and 13
    Posts
    2

    Re: creating spreadsheets using a template and data sheet

    here is the attached file. it has been prefilled and surmarized. I have left two of the forms in tack. I couldn't upload the whole sheet
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor
    Join Date
    08-10-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    721

    Re: creating spreadsheets using a template and data sheet

    Just a word of advice, and I would use fake names as this seems to hold sensitive and personal information. Just a thought.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 01-04-2014, 06:37 PM
  2. Creating New sheet using template
    By sridhar_shri03 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-15-2013, 08:37 AM
  3. VBA - Creating a new named sheet with a sheet template
    By Glensafro in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-09-2012, 06:49 AM
  4. Copy values to template & creating new sheet
    By riceordie in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-29-2007, 03:11 PM
  5. creating new sheet from template and naming them from list
    By meacho in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2007, 09:49 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1