+ Reply to Thread
Results 1 to 2 of 2

Change cell reference/link to new column when value changes

  1. #1
    Registered User
    Join Date
    03-27-2015
    Location
    Fredericton, NB, Canada
    MS-Off Ver
    2010
    Posts
    2

    Change cell reference/link to new column when value changes

    Hello,

    I have been trying to figure this out for a while now with no luck. I have a spreadsheet set up with different screenshots of a PLC HMI screen, each screen shot has multiple textboxes and command buttons where you can fill in the corresponding information you see on the PLC HMI screen. This needs to be filled in every week (not necessarily on the same day each week). I have the textboxes and command buttons linked to a column of cells so when you fill everything in and click the buttons, the values all auto populate a single column.

    Since this needs to be done on a regular basis and I want to keep all previous reading in the spreadsheet for comparison/analysis, I want this column of data to populate a new column on a separate sheet every time the value in the "date" cell changes. The result would be a new column of data every time the screenshots are filled in again. Sorry if this sounds confusing.

    An example for clarity:
    Say I have a "date" cell and textboxes 1, 2 and 3 that populates the first 4 rows of column A on sheet 1. The first week I fill this in, column A on sheet 2 will contain these 4 values. The next week I fill it out again, column A on sheet 1 changes and these new values are sent to column B on sheet 2, and column A on sheet 2 retains last week's data. Each week column A on sheet 1 will change, and the current week's data will be sent to the next empty column on sheet 2. Is this possible with vba?

    Also if possible, I would like to have the data from sheet 1 transfer to the next empty column in sheet 2, then the data deleted from sheet 1. This way each time you go to fill in the data, all boxes are blank making it easier to know which ones still need to be filled in (will be 100+ cells and text boxes to fill in each week, easy to miss some if you are changing existing values rather than simply filling in the empty textboxes/cells).

    Hope someone can help me out with this, very familiar with excel and its formulas/functions but still new to vba.

    Thanks,
    Andrew

  2. #2
    Registered User
    Join Date
    03-27-2015
    Location
    Fredericton, NB, Canada
    MS-Off Ver
    2010
    Posts
    2

    Re: Change cell reference/link to new column when value changes

    Anyone able to help me with this? Or know of any other way I can achieve my desired results?

    Thanks,
    Andrew

+ 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: 02-11-2015, 01:56 PM
  2. Replies: 2
    Last Post: 05-26-2009, 05:55 PM
  3. Replies: 7
    Last Post: 10-01-2006, 08:43 PM
  4. Change the width of a column by using a cell reference
    By None Specified in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-03-2006, 05:00 PM
  5. Can you do calculation for Row or Column for link reference first?
    By KhaVu in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-27-2005, 05:00 PM

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