+ Reply to Thread
Results 1 to 4 of 4

Creating Note Organiser

  1. #1
    Registered User
    Join Date
    11-25-2010
    Location
    Busselton, Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Creating Note Organiser

    Hello everyone, this is my first post here so please be gentle .

    The workbook I plan on creating will function as follows:

    On the first sheet I will be able to type a note in one cell, a title in another and several tags in 1-6 other cells.
    When I click a button the data I have entered with be transfered to sheet2 in a single row for each submission.
    There will be a search cell on sheet1 which will search through the tags on sheet2 and return submissions that have the tag that I have searched for.

    I'm completely new to the programming side of excel but I have done a bit of programming in the past. This means that although I don't know the syntax and structure of the programming I am familiar with the logic structure of programming languages.

    My question then boils down to:
    What is the best way to implement this and what are the most likely commands that I will need to use?

    Where is a good place to learn how to do this myself?

    Additional information that isn't really important:

    The reason I'm doing this is because in my workplace I am not allowed to install any software but I need a note managing tool. Using Excel to program something like this is the only workaround I can think of.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Creating Note Organiser

    Hi mirome and welcome to the forum.

    I'd start by looking at what has already been created. Office has templates that might be just what you need.

    Look at http://office.microsoft.com/en-us/te...in=FX101741961

    I searched for "Notes" but you can search for any term and look at only excel templates if you like.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    11-25-2010
    Location
    Busselton, Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Creating Note Organiser

    Thanks Marvin,
    I've had a look at the templates but none (that I have found) are really what I'm looking for.
    Unless you are suggesting looking at each template just in case it has a function that I could use, in which case I didn't have time to do that just yet.

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Creating Note Organiser

    You might be able to use the Contacts Form example that demonstrates how to create a sheet to act as a form then copy inputs to the data sheet
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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