Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ENTER DATA - LOG ENTRIES ON SEPERATE SHEET (IN SAME BOOK)
Hello guys,
A little Help here...I can't figure it out. I have one sheet in my workbook called DATA. On the DATA sheet, I enter the Last Name in Cell C3, I enter the First Name in Cell C5, I enter the middle name in C7 and the Worker ID in W3. After these cells, I have a command button (Button 6), it is labeled: "ADD TO LOG". I have another sheet in the same workbook called LOG. On this sheet I would like to log each name I enter in the DATA sheet. The first person I enter starts on Row 3. The next person I enter would go in Row 4, and this would keep going.. For example...in the LOG sheet, the first column would have LAST, FIRST MIDDLE in column A; the second column on the LOG sheet would have the worker's ID. I want to be able to push the command button (button 6) and the DATA sheet, and automatically have the data put on the next row down in the LOG sheet. Can someone throw some CODE my way ???? I appreciate it guys. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
flowing data to seperate sheet | Excel Discussion (Misc queries) | |||
Sort out data on seperate sheet | Excel Programming | |||
enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
Data copy from a seperate sheet to data sheet | Excel Programming | |||
Is it possible to export each row of data to a seperate work book | Excel Programming |