applying a formula to single column in an array

Hi
I currently have some code which is selecting 5 cells from a row where one of those cells is a specific number, and copying that data to a new sheet. The source file and cells contain some billing information and the output destination file is an invoice. My source file contains information for many customers, so my copy selection code copies data for each individual customer to a new sheet so I get an invoice for each customer. Here is my current code:

Please Login or Register  to view this content.

Column E in my source data contains my employees hours. When I bill my customers and invoice them I bill 1.5 hours of travel time separately, so I need to deduct that time from my employees hours on the invoice.
Basically I need to subtract 1.5 from each cell in column E when it pastes to the new inovice workbook.

How can I accomplish this?


Any and all help is much appreciated.
Thanks!!!!

Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

Maybe like this. It includes some assumptions on my part.

The Intersect accommodates the case where the UsedRange does not start in col A.

Please Login or Register  to view this content.