Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Schedule - list transfer
I have a weekly schedule in speadsheet form Sun-Sat across the top, 7am to
9pm down that changes weekly with appointments. Some cells never change. Ie lunch, dinner, etc. I would like the all the appoinments each week to fill in a list on another blank form. The day or time is not important on the list, I just need the 1st appt. of the week to fill in the 1st line of the list, 2nd appt....2nd line and so on. It must not list lunch and dinner from the schedule on the list. Any suggestions would be most helpful. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Schedule - list transfer
I would suggest a macro linked to the worksheet_change event. For N = 1 to NumberofColumns For M = 1 to NumberOFRows If Cells(M,N) <"Lunch" and Cells(M,N) <"Dinner" then Sheets(2).cells(65536,1).end(xlup).offset(1,0) = Cells(M,N) End If Next M Next N Define NumberofColumns and NumberOFRows as appropriate. Hope this helps. -- 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=550228 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Change List Based on Value Chosen in Another List | Excel Worksheet Functions | |||
Selecting items from a list. To transfer to another worksheet? | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
How do i transfer certain lines from one list to another | Excel Worksheet Functions | |||
Refresh a Validation List? | Excel Discussion (Misc queries) |