+ Reply to Thread
Results 1 to 2 of 2

adding data to a new column each day that the worksheet is used

  1. #1
    Registered User
    Join Date
    08-23-2012
    Location
    Wisconsin
    MS-Off Ver
    Excel 2003
    Posts
    7

    adding data to a new column each day that the worksheet is used

    I have a worksheet that creates a list of individuals from imported data based on specific criteria. Each day, this information changes. I am attempting to get the spreadsheet to automatically save the list in a column next to the previous day's data. The imported data has the date on it and I would compare it to the current date ' =TODAY(). If the date was different from the last time the spreadsheet was opened, then the data would then be added in a new column. This would allow me to compare the data over a period of time. Any ideas? I have attached the sample worksheet.
    Attached Files Attached Files

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: adding data to a new column each day that the worksheet is used

    Hi dkrzysik,

    The data you posted in column A will move to column G or column D ?
    Also, everytime the new data will appear in column A?

    Though you posted this question in Excel formula and function section but as per me only VBA (macro) is the solution. Thanks.

    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ 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