filtering names into a summary sheet

rayjan

New Member
Joined
Oct 26, 2017
Messages
3
Hi guys, I have the attached billing template. Now, I need to make a summary sheet for it. This summary sheet would have a name filter. For example, if I filter "Joe's" name, it would show data for Joe from all other worksheets.

Can you please help me with this?

By the way, I can't post the file here. I can email it to you if need be. Please let me know.

Thanks.
 
Last edited by a moderator:

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,272
You need to give us specific details about your sheets layout sheet names etc. etc. Asking for us to communicate through email or private message is not the way we do things on this forum.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,418
Office Version
365
Platform
Windows
Welcome to the Board!

You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html. Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

Another option is to upload to a file sharing site like "dropbox" and provide a link. Just note that may limit your pool of potential helpers as many people are unable or unwilling to download files from the internet for security reasons.

Note that I removed your email address from your previous post. You NEVER want to post your email address on a public internet forum like that. Spambots routinely prowl internet forums looking for email addresses to harvest and Spam. If you ever have need to share an email address with someone, you will want to do that directly with them through a Private Message.

Thanks
 

rayjan

New Member
Joined
Oct 26, 2017
Messages
3
You need to give us specific details about your sheets layout sheet names etc. etc. Asking for us to communicate through email or private message is not the way we do things on this forum.
I would attach the file but there is no upload mechanism here.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,418
Office Version
365
Platform
Windows
I would attach the file but there is no upload mechanism here.
Please read my reply. I offered alternatives.
 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,272
I'm one of those type. Even if you loaded the worksheet to this forum I never click on links on this forum. Your question sounds fairly simple so I would think it's best to explain in words what you have and what you want. Be sure and give specific details.

Do not say I have a sheet.
Say: I have a sheet named "George"

Do not say I have a column named "Data"
Say: I have column (3) or Column "C")

For example say:

I have a sheet named "Bob" and I want all the data in sheet named "Bob" column "C" copied into Sheet named "Summary" column "A"

See those are specific details.
 

rayjan

New Member
Joined
Oct 26, 2017
Messages
3
I'm one of those type. Even if you loaded the worksheet to this forum I never click on links on this forum. Your question sounds fairly simple so I would think it's best to explain in words what you have and what you want. Be sure and give specific details.

Do not say I have a sheet.
Say: I have a sheet named "George"

Do not say I have a column named "Data"
Say: I have column (3) or Column "C")

For example say:

I have a sheet named "Bob" and I want all the data in sheet named "Bob" column "C" copied into Sheet named "Summary" column "A"

See those are specific details.
Okay, so I have a sheet called impound and then I have a sheet called TC and finally my summary sheet.
Now, I need to get data from column G and then transfer it into column G in the summary sheet. Now, in column G of summary sheet, I have a filter. This filter would filter employee names. if I filter Joe's name, it must pull all data from Impound and TC with regards to Joe and display it on summary sheet.

So, my biggest hurdle right now is I can't filter other worksheets while I am in summary worksheet.

Any ideas?

Thanks.
 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,272
OK. I'm trying to be nice. But it would be better to tell me what you want and not how to do it.

See your saying you want to take data from one sheet put it into another sheet to do a filter and then copy the data to another sheet.

This is not the way to do things:

Are you saying you want to copy all the rows in sheet named "impound"
If a certain name like "Joe" is in column "G" of sheet named "impound"
And paste these rows into a sheet named "Summary" ?
 

Forum statistics

Threads
1,081,574
Messages
5,359,704
Members
400,545
Latest member
Damntheman30

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top