+ Reply to Thread
Results 1 to 3 of 3

Trying to save input data that is formulated from a sheet where the data is erased daily

  1. #1
    Registered User
    Join Date
    10-07-2018
    Location
    Wichita Falls, TX
    MS-Off Ver
    365
    Posts
    10

    Trying to save input data that is formulated from a sheet where the data is erased daily

    Hello all,

    Here is my situation. I have sheet one where data is inputted and calculated based upon a week worth of dates. That data is used in another sheet which I want to keep track of a quarter based upon dates. Problem that I am having is that when the data is erased it erases it on the quarterly sheet as well. Is there a way to lock that data on the quarterly sheet where it saves once its entered or do I need to figure another way to calculate it.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Perth Western Australia
    MS-Off Ver
    Office 365
    Posts
    257

    Re: Trying to save input data that is formulated from a sheet where the data is erased dai

    Hi

    The simple solution is:-
    Before erasing data go to quarterly sheet select all (click top right cell A1) copy and paste (values to new sheet cell A1) then erase and save. Subsequent copy and paste can re-use the new sheet.

    This procedure could be automated with macro if desired.

    Hope this helps.

    Cheers

    If this solves the issue remember to mark the post as solved. If any post has been helpful consider adding reputation star (Bottom left)


    Hope this helps

  3. #3
    Registered User
    Join Date
    10-07-2018
    Location
    Wichita Falls, TX
    MS-Off Ver
    365
    Posts
    10

    Re: Trying to save input data that is formulated from a sheet where the data is erased dai

    Thank You FoxSeaLady, I will do some research on the macro. I am wanting to make everything easy and automated where all that has to be done is change the begin date of the week and then input the hours data and it calculates the quarter. Will let you know what works.

+ 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: 05-31-2016, 05:24 AM
  2. How can I capture data that is (DAILY) input into another worksheet?
    By Byrd1969 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-25-2016, 01:14 PM
  3. Using VBA to input daily list of data into excel based on date
    By skinmonth in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2016, 01:22 PM
  4. [SOLVED] Help: Calculating MTD, QTD, and YTD from daily data input
    By misterk in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-10-2014, 02:41 PM
  5. How to transfer data from a daily input sheet to a separate monthly total sheet
    By Jcooper71 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2014, 02:37 PM
  6. Using VB to save data from an input sheet to a record sheet
    By JSCR01 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-01-2010, 01:47 PM
  7. [SOLVED] Daily new data input
    By ufo_pilot in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-02-2005, 01:40 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