Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic completing of names and ID numbers - Problem.. help
How about this one for a first post - I am trying to code in VBA fo Excel 97 a program that will take from a list of staff (with payrol numbers) on one sheet in a workbook the name and ID into the correc cells in a pre-created signing on sheet which is in the same workbook. I have managed to figure out (on paper) how to activate the defaul sheet, copy and rename it and then delete it when I'm finished bu after that I'm stumped. Basically I have no idea how to get it to cop the cells over, move down the list and then keep on going no matter ho long the list is on. I've attached a copy of sheet I am working on (so you can see th format of the signing on sheet mainly), any help would be massivel appreciated. This is my first real attempt at doing this sort of thin but I have done programming before. So even just pointing me in th direction of where to go (careful ;-) would be cool. Thanks for any help. Lurch Kimded < +---------------------------------------------------------------- | Attachment filename: signon.xls |Download attachment: http://www.excelforum.com/attachment.php?postid=369268 +---------------------------------------------------------------- ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic completing of names and ID numbers - Problem.. help
Sub CreateTimeSheets() Dim myRange As Range Sheets("Staff_List").Select Range("A1").Select Set myRange = ActiveCell.CurrentRegion LastRow = myRange.Cells(myRange.Cells.Count).Row For i = 1 To LastRow ' put in here whatever it is you want to do with each name on your list Next i End Sub ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what could cause numbers to appear as row names and column names | Excel Worksheet Functions | |||
Automatic Page Number and Sheet Names? | Excel Discussion (Misc queries) | |||
Macro NOT completing | Excel Discussion (Misc queries) | |||
Automatic File Names | Excel Discussion (Misc queries) | |||
sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) |