View Single Post
 
Old 11-28-2018, 06:15 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

@trevorc
you've still neglected to mention:
- the name of the sheet the Worksheet_Change event would be used on
- the column or range of cells the Worksheet_Change event would be restricted to
- the location (ie: starting column) where Sheets("Customer").Range("I" & t & ":L" & t) would be copied to
- the location (ie: starting column) where Sheets("Customer").Range("Y" & t & ":AH" & t) would be copied to

Posting a sample workbook would be to your advantage.
Reply With Quote