asked on

Copy data from an excel tab to another tab live update

I have a table setup in a tab called Team Names, I want to be able to copy that table to a summary tab in the same sheet, but if there are names added to the table in the team names tab in the future I want them to automatically update the Summary tab

jppinto

Let me see if I understand your question:

You have a sheet (tab) called Team Names;
You have another sheet (tab) called Summary, on the same workbook;
When you enter a name on sheet Team Names, you want to copy that row to the Summary sheet?

jppinto

sharris_glascol

ASKER

yes..

jppinto

What happens when the user deletes an entry on the Team Names?

sharris_glascol

ASKER

won't happen..

jppinto

On sheet Team Names, the number of columns filled for each name is always the same? How many?

sharris_glascol

ASKER

Here is what the data is in Team Names tab

Names        Angler ID
Wil Newlin - Steve Bauer        1107-01
David Farrell - Ron Hayne        1107-02
Derek Coon - Don McLain        1107-03
Jamie Waters - Justin Moore        1107-04
Don Tingley - Richard Summers       1107-05
Jim Vanzo - Gary Long        1107-06
Aaron Ivy - Richard Ivy        1107-07
Bob Lynch - Bill Berry        1107-08
Keith Allen - Charlie Allen        1107-09
Billy Caudill - Rob Caudill        1107-10
Chris Lally - Mike McDonald        1107-11
Kevin Altmeyer - Jeremy McKenzie 1107-12

ASKER CERTIFIED SOLUTION

jppinto

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial