Microsoft Excel - automatically copy rows and columns to another worksheet

I am an Excel novice, so this may be a very basic question -

I have a list of clients in a worksheet in Excel (with columns 'Name', 'Title', 'Company'). What I want to do is copy the list to another worksheet through some sort of link or formula, such that when I add rows to the client list worksheet, this is reflected in the other worksheet; and when I delete rows, or change data in cells, these changes update automatically in the other worksheet.

I think VLOOKUP is how to do it but I'm not sure, VLOOKUP requires common data between worksheets and I don't really have that here - I just want to show data from one worksheet in another, so I can add columns to show other kinds of info for these clients.
RobertAtFoxAsked:
Who is Participating?
 
Saqib Husain, SyedEngineerCommented:
If the first sheet is Sheet1 then enter this formula on sheet2 A1 and then copy it down and across as far as required

=IF(INDEX(Sheet1!$1:$1048576,ROW(),COLUMN())="","",INDEX(Sheet1!$1:$1048576,ROW(),COLUMN()))
0
 
Rob HensonFinance AnalystCommented:
Simple question which might not have a simple answer:

Why do you need a copy of the list in another sheet? Can you not add the other columns alongside the original list?

Thanks
Rob H
0
 
Martin LissOlder than dirtCommented:
I've requested that this question be closed as follows:

Accepted answer: 500 points for Saqib Husain, Syed's comment #a40716150

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.