+ Reply to Thread
Results 1 to 7 of 7

Transfer cell information into a new free cell and clean after pressing enter

  1. #1
    Registered User
    Join Date
    09-11-2013
    Location
    Sofia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Transfer cell information into a new free cell and clean after pressing enter

    First of all I want to say HELLO to everyone. This forum is a great place and you guys are amazing.

    Could you please help me to find a solution to a strange task.
    I would like to make a workbook with a couple of sheets.
    The most important data for me will be on the sheet 1.
    Is it possible to have 3 cells in sheet 1 and to use them just to insert data (numbers), but after pressing enter i need this data to be transferred into sheet 2, or 3 or 4, and cell to be clear again and ready for a new number.

    I hope i could explain it well so you can understand me.

    Thank you very very much!!!
    Y

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019; O365
    Posts
    19,163

    Re: Transfer cell information into a new free cell and clean after pressing enter

    Yes, this is within the realm of Excel. It will have to be completed using VBA. If you post a copy of your workbook with before and after examples, I am sure that one of our outstanding volunteer members will have a solution for you.

  3. #3
    Registered User
    Join Date
    09-11-2013
    Location
    Sofia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Transfer cell information into a new free cell and clean after pressing enter

    Thank you very very very very much.
    I desparately need this workbook. It's so important for me and the job i want to do.

    Actually I still don't have a workbook, because i don't know how to start it.
    It's going to be something like this:workbook.xlsx
    But what i need to do is , USING ONLY EXCEL 2003:
    - cells B2:G5 to remain always empty and when I insert number inside and press Enter to do 2:
    1) H2:H5 to calculate respectively "=B2-C2+D2-E2-F2-G2"; "=B3-C3-E3-F3-G3+D3"; etc... but taking in consideration all the numbers inserted in cells B2:G5, accumulating them
    2) B6:G6 to sum all the above cells, but again taking in consideration all the numbers inserted before

    Once again -THANK YOU!!!!

  4. #4
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Transfer cell information into a new free cell and clean after pressing enter

    There is something that i don't understand..

    In H2 you have this formula.

    =B2-C2+D2-E2-F2-G2

    Why does not this formula works ok? Can you explain a little more pls?
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  5. #5
    Registered User
    Join Date
    09-11-2013
    Location
    Sofia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Transfer cell information into a new free cell and clean after pressing enter

    well the formula works OK, but it's not what i want to do.
    what i need is to keep cells B2:G5 to always empty and when I insert number inside and press Enter this number to goes somewhere else , to sum to the other numbers transferred there from the same cell, and then calculate H2 taking in consideration all the numbers inserted in cells before till this moment
    Maybe I can't explain well

  6. #6
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Transfer cell information into a new free cell and clean after pressing enter

    Quote Originally Posted by juliangun4ev View Post
    Maybe I can't explain well
    OR

    Maybe i don't understand well!

    So let's wait to see if someone else will be able to helps here!

  7. #7
    Forum Contributor
    Join Date
    01-18-2013
    Location
    Prague, Czech rep.
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    138

    Re: Transfer cell information into a new free cell and clean after pressing enter

    Hi Juliangun4ev,

    Ive checked on your example and it can be done, Not sure if within the boundaries of formulas & functions but within macros most certainly. Thing is, without final example how the file should look like is kinda hard to figure out because of few reasons:

    1) dunno the structure where in the following sheets you want the results
    2) cant decide like this where to use absolute reference and where relative
    3) there will be quite a lot of global variables to achieve what youre looking for, So one might wanna ask if its necessary to clear the field straight after pushing enter button, if it werent better to make a button to clear the selection or make something else to clear the range ... would clear those global variables of the table and the file would be much faster and less messy, also it might bring up the file back to formulas&functions boundaries

    Id suggest you to make more precise example, cause like this Its immense heap of work to catch all the possibilies and to give you some code to execute what you want....which i feel like is not necessary

    EDIT: OR, just realized, you might need to use one trick Im using (calling it myself mirroring) which is making a worksheet containing all the background dirty work hidden from the users, where youd be keepin all those inputs whilst frontpage remains empty and clear, which would be somewhat halfway between what youve said above and what youve described as desired outcome....but still would appreciate more precise example
    Last edited by SoulPrisoner; 09-12-2013 at 04:00 AM.

+ 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. Reselect cell after pressing enter
    By randell.graybill in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-19-2010, 10:38 PM
  2. Alt + Enter when pressing enter in cell?
    By Stiff in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-20-2009, 05:31 AM
  3. Auto Jumping to next cell without pressing enter
    By Steve Brown in forum Excel General
    Replies: 1
    Last Post: 01-21-2008, 02:47 PM
  4. Active Cell after pressing the Enter Key
    By RealNewbie in forum Excel General
    Replies: 2
    Last Post: 10-17-2007, 09:56 PM
  5. [SOLVED] HOW DO I GET THE ANSWER TO A FORMULA BY PRESSING ENTER IN CELL?
    By E-QUIP in forum Excel General
    Replies: 1
    Last Post: 05-31-2006, 12:10 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