Robert Reisig
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
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