Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy&Paste variable range based on cell value
Hi community,
Worksheet 'Dump' contains data in column A:G, variable number of rows. The data is sorted by column D descending (values being "c", "b", "a"). I want to copy & paste only the rows with "c"'s and "b"'s So, I need a macro that - finds the last row of my needed range (as soon the macro finds an "a" in cell Dx) - selects the range (column A,B, row 1 to last needed row) and copies it to a worksheet "Comments" to cell A1 Thanks a bunch in advance for your help Thomas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy&paste a variable range rows and colums | Excel Discussion (Misc queries) | |||
How to Copy and Paste a variable range | Excel Programming | |||
Finding a named range based on cell value and copy/paste to same sheet? | Excel Programming | |||
Setting a range within a loop variable for copy/paste | Excel Programming | |||
Copy/paste range variable between workbooks | Excel Programming |