UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Help With Copying To Empty Cells, Office 2007    
 
   
NineIron
post Feb 16 2017, 12:29 PM
Post#1



Posts: 2,107
Joined: 18-September 03
From: Massachusetts


I know there is a "process" to copy cells into blank cells but, my case is..........I need to copy cells into cells with an empty string. Or how can I make the cells blank? See attached.
Attached File(s)
Attached File  Example.zip ( 9.18K )Number of downloads: 3
 
Go to the top of the page
 
Daniel_Stokley
post Feb 16 2017, 02:30 PM
Post#2



Posts: 193
Joined: 22-December 14
From: Grand Junction, CO, USA


Speaking only for myself, it is not at all clear what you want to do. Can you please elaborate?
Go to the top of the page
 
NineIron
post Feb 17 2017, 06:20 AM
Post#3



Posts: 2,107
Joined: 18-September 03
From: Massachusetts


The original file is a list of employee's SSNs. The employees are either eligible for benefits or not, "Y" or "N". I left the SSNs out of this file for obvious reasons. In the attached file there is a row for each month with either an "N" or "Y" in column B, "Eligible", next to the month number. There are hundreds of SSNs in the file and I need to move the employees without any benefits in all 12 months to another sheet. The ones that I need to move have an "N" in the column next to each SSN so, a total of 12 Ns. My thought was to use an IF statement to put a 1 or 0 then, total up the range for each month of SSNs. This is where I get stuck and don't know what to do next.
Go to the top of the page
 
Daniel_Stokley
post Feb 17 2017, 11:40 AM
Post#4



Posts: 193
Joined: 22-December 14
From: Grand Junction, CO, USA


OK, that helps.
How about this. First, freeze the top row (title row). Then turn on filtering. Then, in your "DDD" column, filter out all but the zeros.
I've added a new column A titled EmpID. In my example each EmpId is just a single letter. In your case it would be the SSN.
Here is what my example looks like with the filtering applied:
Attached File  Example1Filtered.gif ( 5K )Number of downloads: 0


So, in this case, Employees D and E would be copied to the other sheet or book.
Go to the top of the page
 
NineIron
post Feb 17 2017, 11:44 AM
Post#5



Posts: 2,107
Joined: 18-September 03
From: Massachusetts


Good idea. Thanx.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    29th March 2017 - 05:50 PM