+ Reply to Thread
Results 1 to 2 of 2

Button to save certain cells in row to another sheet.

  1. #1
    Registered User
    Join Date
    01-30-2013
    Location
    Nottinghamshire
    MS-Off Ver
    Excel 2007
    Posts
    2

    Thumbs up Button to save certain cells in row to another sheet.

    Hi Guys, my first day on the forum.
    I have a problem, i need to keep track of changes to documents whos information is entered into sheet 1, and would like to have a comments field on sheet1. My problem is, i would like to take the comments from the row on sheet 1 along with information (dates & version numbers) from Row 1, column 1,3 and 5, and store them on a new sheet, then use a list box or combo box on sheet 1 to view this information along with past comments.
    I know its asking a lot but i cant seem to find anything that will help me.
    Thanks in advance.

  2. #2
    Registered User
    Join Date
    01-30-2013
    Location
    Nottinghamshire
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Button to save certain cells in row to another sheet.

    A bit more information..... what i am trying to achieve is something that is easy in Access but some of the users dont have access to Access i am wanting a history of ammendments to a cell called Changes (1 row per document/Customer) that is viewable without taking up lots of rows of the sheet. Viwing this history in a listbox or command box would allow minimum disruption of the table format. A bit like a comment box but using form control or ActiveX controls.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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