Copy Entire Row of Data from One Worksheet to Another Within the Same Workbook.

Hello:

I'm wondering if there is a way to copy the entire row of data from one worksheet into another, within the same workbook, based on the criteria "Person." Here is the spreadsheet with bogus data. You'll see several column headings entitled "Heading 6", "Heading 7", etc. to show how many total columns of data there are, just in case it will be helpful for VB coding (if that's a solution).

Is there a way to have only the "Smith" rows copied and pasted into another worksheet entitled "Smith," and the "Jones" rows copied into another worksheet entitled "Jones," etc? I'm not at all knowledgeable about macros or VB programming, but maybe that is the way to go?

Many thanks in advance.
Ralph

How often will you be doing this task?

Is there any reason you don't just sort by person name and then copy and past into separate sheet?

A VB macro would definitely do it for you but you'd need to answer a few questions..

You say you want to copy Smith and Jones rows into another worksheet.

a) Which worksheet (A specifically named sheet, the first sheet in workbook, the next sheet along?)
b) Will it always be Smith and Jones or will the names vary.
c) when copying into the new sheet should it delete the contents that already exist or add to the bottom?

I may be going overboard but I know people may not think about possible problems down the line.

Regards,
John

Well, the group for whom I'm trying to create this for wants it to be as automated as possible. My first thought was to merely use a filter, but they didn't want that solution.

a) I don't care what order the new tab names are in. They can be in any order as long as each unique name has its own separate tab.

b) For the most part, the names will be consistent, but I wouldn't rule out the fact that at some point a new name may be added, or an existing name may be deleted.

c) They would want the original contents of each individual sheet to remain, and add additional information to the bottom.

Many thanks, John.

Ralph

Originally Posted by johncassell

How often will you be doing this task?

Is there any reason you don't just sort by person name and then copy and past into separate sheet?

A VB macro would definitely do it for you but you'd need to answer a few questions..

You say you want to copy Smith and Jones rows into another worksheet.

a) Which worksheet (A specifically named sheet, the first sheet in workbook, the next sheet along?)
b) Will it always be Smith and Jones or will the names vary.
c) when copying into the new sheet should it delete the contents that already exist or add to the bottom?

I may be going overboard but I know people may not think about possible problems down the line.

Regards,
John

Hi again,

sorry this has taken so long and hope it is still needed. I've attached the spreadsheet which will hopefully do what you want.

It has 3 sheets

1. Named 'JHFunds-Master' which will contain all the data.
2. A sheet called 'Names' which lists all the names to look for (and the macro button to start the macro)
3. A sheet named 'Copy' with the same headers as the JHFunds-Master sheet and will recieve the copies of the rows relating to the names you have selected.

If you have any questions do not hesitate to ask.

John

Thanks, John. I really appreciate your help.

No problem,

let me know if theres anything you don't understand.

John

Hello, I know this is a very old thread, but it is the closest to what I am looking for. I am pretty much teaching myself VB as I go with the projects my manager gives me. I need also copy over rows from one sheet to another, but it needs to be based on the date. This excel is the location where all the people who have called in sick are documented and the occurrences are tracked. But after a year, the occurrences are dropped. So it needs to automatically roll off everyday.

The sheet where the data is stored is called "Call In's" and the tab where the outdated information goes is called "OldEntries"

The range of cells being used in a row is from A to J at the moment (the end could change as we put more data in there). The date the data is entered is in the column E.

Thank you so much for your help. I am not fidning the answer anywhere.
Holly