I need an Excel Wiz!

Denvernative · 06-20-2007, 07:57 AM

I have a spreadsheet with a list of approx 300 employees. When I run a Macro, it pulls data from a different location to find out if any employees were tardy for the day. Then, in order to indicate if an employee was tardy, it posts a red block marked "1" in the cell that coincides with that employee and the date of the tardy.

My question is, how can I filter out the employees that are not tardy so that I can copy out just the ones who are tardy?

If you can help me, I will love you forever!
Denvernative

Codeman0013 · 06-20-2007, 09:28 AM

You can simply do a search on that field for the 1 and then say find all and then hit ctrl+a when its done and then ctrl+c and move them to another sheet it will highlight and move the entire row.

**Glaswegian** · 06-20-2007, 01:26 PM

As an alternative, use Autofilter, filter on your column with the "1", then copy and paste the results.

06-20-2007, 07:57 AM	#1 (permalink)
Denvernative Registered User Join Date: Oct 2006 Posts: 4 OS: Win 2000	I need an Excel Wiz! I have a spreadsheet with a list of approx 300 employees. When I run a Macro, it pulls data from a different location to find out if any employees were tardy for the day. Then, in order to indicate if an employee was tardy, it posts a red block marked "1" in the cell that coincides with that employee and the date of the tardy. My question is, how can I filter out the employees that are not tardy so that I can copy out just the ones who are tardy? If you can help me, I will love you forever! Denvernative

06-20-2007, 09:28 AM	#2 (permalink)
Codeman0013 Registered User Join Date: May 2007 Location: Decatur Illinois Posts: 257 OS: Windows 7 My System	Re: I need an Excel Wiz! You can simply do a search on that field for the 1 and then say find all and then hit ctrl+a when its done and then ctrl+c and move them to another sheet it will highlight and move the entire row.

06-20-2007, 01:26 PM	#3 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,489 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Re: I need an Excel Wiz! As an alternative, use Autofilter, filter on your column with the "1", then copy and paste the results. __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner