+ Reply to Thread
Results 1 to 1 of 1

Create excel template to capture data

  1. #1
    Registered User
    Join Date
    07-12-2019
    Location
    Bangalore, India
    MS-Off Ver
    2010
    Posts
    1

    Create excel template to capture data

    Hi All,

    I am looking to create an excel template where there will be five icons. I want to assign numbers 1,2,3,4,5 respectively. When the user clicks on the image (like push button) it should store the assigned value in another workbook (not same template). The data stored in the another workbook has three headers - Date, Name, Factor; where the Factor is the assigned value.

    If this template is used by a 10 member team, then all the records are stored in the non template workbook for analysis.
    Is this doable in Excel?

    I have a beginner level understanding. I believe using forms we can do this but not sure how? I did spent some time on this too.

    Thanks.
    Last edited by Pradeepmk; 07-12-2019 at 11:44 AM.

+ 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. [SOLVED] Create List - Index Match or Index Aggregate or other?
    By bambamclint in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-10-2019, 01:30 PM
  2. [SOLVED] VBA - Create New Sheets Based on Index Sheet Cell Values with Link to Index Sheet
    By order in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-02-2017, 06:23 PM
  3. [SOLVED] Create an index keeping original index reference and appending new where necessary
    By BRISBANEBOB in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-30-2016, 01:38 PM
  4. [SOLVED] Create an index keeping original index reference and appending new where necessary
    By BRISBANEBOB in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2016, 01:34 PM
  5. [SOLVED] Create sheets Index
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-31-2014, 10:21 AM
  6. Create an Index
    By schihuly in forum Excel General
    Replies: 0
    Last Post: 11-01-2011, 03:13 PM
  7. Replies: 5
    Last Post: 04-18-2010, 11:06 AM

Tags for this Thread

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