How I can do that by MS-Excel:? - loli link list bbs gateway and bookmark this site
my boss asked me to do and so many do not know how:
I started this list with the names in the first column:
Jack
Sami
loli
lala
Meme
Then the next column, I randomly selected some of these names and write them in a row and I need that excellence for the names I have not written and put to find in series. Open the link below to see how.
http://mypictures2008.blogspot.com/
Friday, February 19, 2010
Loli Link List Bbs Gateway And Bookmark This Site How I Can Do That By MS-Excel:?
Subscribe to:
Post Comments (Atom)
1 comments:
When you have finished your work, it will be a list of names in column A and some of these names are repeated in line 1, where an empty cell, prior to the last row.
You want a macro to the complete line 1, column names that are more in line 1. As the name in cell A1 and is in line 1, which have never been on the line 1 resumed. The macro does not delete the duplicates in row 1 or names on the line 1, which is missing in Colunm A.
Place the following code in a module project and decide how you want to run.
Finish Names (sub-)
ICol iRow As Long
Active Sheet
iRow = 2
Do While. Cells (iRow, 1)> ""
iCol = 2
Do While. Cells (1, iCol)> ""
Si Cells (iRow, 1) =. Cells (1, iCol) Then Exit Do
iCol = iCol + 1
Loop
Si Cells (1, iCol) = "" Then. Cells (1, iCol) =. Cells (iRow, 1)
IRow = iRow + 1
Loop
End With
End Sub
If you are in cell A1 in your name somewhere in row 1 again, simply change the statement iRow iRow = 2 = 1.
Further details can be modified PLA from someone who knows
Post a Comment