+ Reply to Thread
Results 1 to 2 of 2

How to transfer data from a daily input sheet to a separate monthly total sheet

  1. #1
    Registered User
    Join Date
    01-24-2014
    Location
    Tyler, Texas
    MS-Off Ver
    Excel 2003
    Posts
    1

    How to transfer data from a daily input sheet to a separate monthly total sheet

    I am working on a daily inventory spreadsheet and want to make it where everything that has to be typed in each day is under the same tab. I have attached a smaller example of what im working on. I want to be able to enter the data daily under the input tab and for that data to transfer over to the other tabs. The biggest problem I have is that everytime I change the data in the input page, the old data is erased from the monthly totals. Is there any way to correct this?
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    Re: How to transfer data from a daily input sheet to a separate monthly total sheet

    You have an update Button on the input tab, but you have not provided the code that it uses to update your details. How can we help you with this issue, if you don't give us something to analyze?
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Enter data in one sheet and keep a running total in separate sheet
    By dvelosky in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2013, 01:45 PM
  2. Transfer single column input data to fixed table in a separate Sheet
    By Prokis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-07-2012, 05:37 AM
  3. Copy Daily data to Monthly data sheet
    By jbeardslee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2012, 08:39 AM
  4. Move data from daily to monthly sheet
    By itsunclebill in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-13-2010, 08:04 AM
  5. [SOLVED] I need a daily sales sheet to pull from monthly figures sheet
    By Draegen in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-24-2005, 05:26 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