transfering text from 1 table to another automatically

sandych

New Member
Joined
Jul 3, 2019
Messages
1
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.
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,762
Office Version
2013
Platform
Windows
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,101,759
Messages
5,482,704
Members
407,359
Latest member
aaawww

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top