ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA to Copy Range (https://www.excelbanter.com/excel-programming/393476-vba-copy-range.html)

gumby

VBA to Copy Range
 
I need to copy a range from sheet 1 to sheet2 and copy it directly
below a cell that eqauls a cell value on sheet1.

So if Sheet1 Cell A1 equaled 7:00 AM I would want the range copied to
sheet2 directly below the Cell with a value of 7:00 AM in it.

Thanks - David


Vasant Nanavati

VBA to Copy Range
 
Please don't post the same question in more than one group. See my answer to
your identical post in .worksheet.functions.
__________________________________________________ ________________________

"gumby" wrote in message
ups.com...
I need to copy a range from sheet 1 to sheet2 and copy it directly
below a cell that eqauls a cell value on sheet1.

So if Sheet1 Cell A1 equaled 7:00 AM I would want the range copied to
sheet2 directly below the Cell with a value of 7:00 AM in it.

Thanks - David





All times are GMT +1. The time now is 05:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com