Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
http://www.cpearson.com/excel/events.htm
has information on events. I suspect you would want to use the change event to execute the code. -- Regards, Tom Ogilvy "Tommy" wrote in message ... Patrick and Tom I got everything to work, but how do I get it to auto update sheet2 when I make a change on sheet1. "Patrick Molloy" wrote: all Tom did was simply copy the table to a new sheet and then sorted it. yuo can try this yourself by switch on the mavro recorder, copyiny the table to another sheet and then sort it. switch off the macro recorder and examine the code generated. It won't look exactly like Tom's as it will be more specific, but it's a good way to learn. "Tommy" wrote: Tom Thank you for the reply, but I am new at this, I do not understand. Could you explain a little more please. "Tom Ogilvy" wrote: Sub AA() With Worksheets("Sheet1") .Range("A1").CurrentRegion.Resize(, 2).Copy _ Destination:=Worksheets("Sheet2").Range("A1") End With Worksheets("Sheet2").Range("A1") _ .CurrentRegion.Sort Key1:= _ Worksheets("Sheet2").Range("B1"), _ Order1:=xlAscending End Sub -- Regards, Tom Ogilvy "Tommy" wrote in message ... On sheet1 I have a list of names from a to z in column a, in col b is a score, I want to transfer that information to sheet2 with the lowest score listed first. I need to transfer the name also with the score. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
How to find a data in Sheet1,automatic transfer to Sheet2(Excel) | Excel Discussion (Misc queries) | |||
copying data from sheet1 to sheet2 | Excel Worksheet Functions | |||
How To Retrieve Data from Sheet2 into Sheet1 | Excel Worksheet Functions | |||
creat and transfer data sheet1 to sheet2 | Excel Programming |