+ Reply to Thread
Results 1 to 6 of 6

Excel Information Saved To Another Document

  1. #1
    Registered User
    Join Date
    09-16-2021
    Location
    Wisconsin, United States
    MS-Off Ver
    Excel
    Posts
    3

    Post Excel Information Saved To Another Document

    I need to make an excel sheet for work that specifies damage to screens, and which ones are out of commission. I have check boxes next to each screen that is damaged. Once the screen is fixed they can uncheck the screen that is damaged. What I need is every time a screen is damaged it logs the information into another document so we can track which ones keep getting damaged. I don't want to have to type the information in this excel sheet and then in another document. Is there a way to link two so it automatically logs it in a different document? (Which screen was damaged, when it was damaged, cause).

    It would also be nice if after the screen is fixed, when the check box is un-checked the information in the corresponding cells is cleared.

    Any help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Excel Information Saved To Another Document

    Short answer - no, not with formulas. You will need VBA for this
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    09-16-2021
    Location
    Wisconsin, United States
    MS-Off Ver
    Excel
    Posts
    3

    Re: Excel Information Saved To Another Document

    I have 3 cells, once is check box, the next one is "Date", and the next one is "Reason". When the checkbox is unchecked i would like Date and Reason to be deleted. What would I put in the IF statement to make this work? Attachment 748574

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Excel Information Saved To Another Document

    Your attachment doesnt work. If you already have manually entered data in Date and Reason, you will need VBA for delete those entries - formulas can only affect the cell they reside in, and you can only have data OER a formula in a cell, you cant have both.

  5. #5
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,293

    Re: Excel Information Saved To Another Document

    With a little different layout I make this for you.
    In tab 'log' you fill in the damage en the solution.
    In Tab 'status' you can see which screen is broken.
    You can split it on 2 files, Then you need both files opend
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  6. #6
    Registered User
    Join Date
    09-16-2021
    Location
    Wisconsin, United States
    MS-Off Ver
    Excel
    Posts
    3

    Re: Excel Information Saved To Another Document

    This is what I have so far. Whats going to happen is a screen from work will become damaged. You the corresponding checkbox. Fill out the information of when and how it was damaged. When its fixed you uncheck the checkbox and the corresponding cells next to it (Date, reason) are cleared. I keep trying to use IF statements but i keep getting an error.

    It would be

    A1(Checkbox), A2 (Date), A3 (Reason)
    So A1 is checked and A2, A3 is filled out. Then when A1 is unchecked = A2 and A3 are cleared.

+ 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. Excel 2010 Save as PDF - Document not saved
    By rustleg in forum Excel General
    Replies: 3
    Last Post: 10-09-2019, 02:48 AM
  2. Replies: 4
    Last Post: 04-24-2013, 02:54 PM
  3. Excel 2010 saved document to be spell checked
    By Leonieimwhatim in forum Excel General
    Replies: 0
    Last Post: 04-22-2013, 08:46 PM
  4. Replies: 5
    Last Post: 10-01-2008, 08:30 AM
  5. Open an excel document prio to it last being saved
    By C Dillon in forum Excel General
    Replies: 1
    Last Post: 03-03-2006, 09:30 AM
  6. Why do I get an error Document not Saved in Excel?
    By Helena in forum Excel General
    Replies: 1
    Last Post: 02-06-2006, 11:20 AM
  7. Document not saved (Excel 97)
    By Optiglaze in forum Excel General
    Replies: 0
    Last Post: 07-25-2005, 04:05 AM
  8. [SOLVED] How do I recover Excel document printed but not saved
    By Richard AH in forum Excel General
    Replies: 1
    Last Post: 07-12-2005, 03:05 PM

Tags for this Thread

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