Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically adding a row to a list
Hi I am using Excel 2002 and I am having a problem. I have a large form where I enter data against people over a weekly period. For each person, I have three rows per day where I can enter info. This is nomrally enough but ocassionally I need more rows for a particular person. What I would like happen is that when I type in the final row for that person, for another row to automatically insert itself below the row I am typing into. I have looked and I think there is a built in function to do this in version 2003 but not 2002. To be ultra fuzzy it would be even better if the row that is automatically inserted kept the same format as the row above it. This is becuase some of the columns have merged cells and some do not. Any help would be greatly appreciated... -- mayerc ------------------------------------------------------------------------ mayerc's Profile: http://www.excelforum.com/member.php...o&userid=35447 View this thread: http://www.excelforum.com/showthread...hreadid=559871 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically adding a row to a list
I would suggest a macro linked to the Worksheet_Change event. You could test if the row was the last of the three, insert a new row below and then copy/paste special formats from the original. -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=559871 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a List of Members to a shared workspace | Excel Discussion (Misc queries) | |||
How to Change List Based on Value Chosen in Another List | Excel Worksheet Functions | |||
list worksheet macros/VBA without adding worksheet | Excel Discussion (Misc queries) | |||
How can I fill data in a list automatically? | Excel Discussion (Misc queries) | |||
adding data from one sheet to another sheet as a dropdown list bo. | Excel Discussion (Misc queries) |