transfering text from 1 table to another automatically
Results 1 to 2 of 2

Thread: transfering text from 1 table to another automatically
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2019
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default transfering text from 1 table to another automatically

    My apologies to start off with. I am teaching myself and need some assistance.

    I have a table that has columns. what I want to happen is that when I enter new data into this table it will send it to my other table without having to enter it all over again. what formula would I use?

    I want it to grab the text in column 2 and data from columns 5 and 7 only.

    Any help would be appreciated.

  2. #2
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    15,683
    Post Thanks / Like
    Mentioned
    28 Post(s)
    Tagged
    13 Thread(s)

    Default Re: transfering text from 1 table to another automatically

    I see you are new to the Forum.
    It's always best when asking questions to be very specific.

    For example you said I have a table

    A Table and a sheet are not the same.

    So please provide the two Table names or the two sheet names.

    A Table is a Range on a sheet.

    And you said:
    I want it to grab the text in column 2 and data from columns 5 and 7 only.

    Grab it and put it where?

    We would need to know other Sheet name and where on the sheet.

    So if you would provide more specific information I may be able to help you.

    And are you willing to use Vba?
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please I’m not perfect yet. "Memories are forever"

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •