Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
autofill or copy & paste "till a value"
Hello, perhaps a simple problem...but...:-(
I've got four columns (A B C D) of data in sheet 1. In columns B there are increasing value (integer 1,2,3,4,5...200) In sheet one, in cell E1 there is number (that comes from other data), for example "78" Now, in sheet 2 I need to do sthg as "copy & paste" columns from A to D of sheet1 but only if B values are <=E1.... How can I do this in Vba...?? Actually I copy the A1:D1 range and, by using an if statement (if B1<=$E1$1) autofill down columns...but I can't "stop" automatically the autofill function.... If possible I wish to use a "for" routine (so that I can understand to solve other similar problems by myself...) Thanks in advance...! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
addera 1 till cell "automatiskt" | Excel Discussion (Misc queries) | |||
how to copy a pivot table and "paste special" formats in excel 07 | Excel Discussion (Misc queries) | |||
problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
Auto "copy and paste" individual cells from various sheets into one sheet ?? | Excel Discussion (Misc queries) | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |