+ Reply to Thread
Results 1 to 7 of 7

offseting to another table

  1. #1
    Registered User
    Join Date
    02-28-2017
    Location
    USA
    MS-Off Ver
    office 360
    Posts
    14

    offseting to another table

    Untitled.png

    I had help with this coding I'm not a coder my self and I want to learn but never got a chance but is there a way to make the info I put in cell B20-B40 go to another table too where it just shows the total on that table in the offset and on another table show every number entered so I can see what I put into that cell

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: offseting to another table

    Hello matthew1990,

    It would be much better if you could attach a sample workbook instead of an image.

    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

    Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Registered User
    Join Date
    02-28-2017
    Location
    USA
    MS-Off Ver
    office 360
    Posts
    14

    Re: offseting to another table

    here is a test form
    Attached Files Attached Files

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: offseting to another table

    Hello matthew1990,

    Thank you for the feedback.

    Maybe?

    Please Login or Register  to view this content.
    Regards.

  5. #5
    Registered User
    Join Date
    02-28-2017
    Location
    USA
    MS-Off Ver
    office 360
    Posts
    14

    Re: offseting to another table

    that's kind of what I wanted but I want it to keep offsetting on sheet 1 to see a total amount but then I want sheet2 to be a ledger of what I placed in sheet 1

  6. #6
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: offseting to another table

    Did you check Sheet2? Fill out Column B in Sheet1, and that will Copy to Sheet2.

  7. #7
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: offseting to another table

    Hello matthew1990,

    Maybe this will suit you better?

    Please Login or Register  to view this content.
    If not, please let me know. Must admit that I am a bit lost with your exact requirement, but please bear with me, I shall give you my best to eventually give you what you want,

    Regards.

+ 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: 6
    Last Post: 01-24-2017, 06:56 PM
  2. Macro to fill 1st table with info from 2nd table. 2nd table search with 2 conditions
    By Ribeiro.JD in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-17-2016, 02:03 PM
  3. [SOLVED] Adding a row in a table corrupts formula in a summary table (2nd table)
    By How How in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2015, 02:35 PM
  4. Replies: 0
    Last Post: 07-02-2013, 11:30 AM
  5. [SOLVED] Need a formula to sort a table into table (for a Table Plan) and name in column 2
    By jbpianoman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-07-2012, 09:21 AM
  6. Offseting referenced Cells
    By kickme in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-27-2012, 07:33 AM
  7. [SOLVED] PIVOT TABLE - Summary Table into a Databasae Table.
    By sansk_23 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-09-2005, 03:06 AM

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