TSmith
11-24-2008, 01:29 PM
While I have written a few simple VBA macros before, this one is making my head hurt. I am trying to figure out how to search a named range and if the specific condition is met, copy certain cells to another worksheet. Specifically, I have a worksheet (Trip Cards) that contains 40 "cards" of information. Each card occupies 20 rows by 16 columns and they are arranged two cards across and 10 cards down. I need to search the named range "TripNum" and if the cell on a given card contains the letter C, copy certain cells to the Cancelation worksheet. The cells to be copies are offset from the Trip Number cell on the first card as follows:
Trip Number is D1
Date is G1
Group is C5
Driver is B19
The offsets will reamin the same for all other cards and be indexed against the Trip Number cell that contains the "C". For each card to be copies, I need it to go to the next available line on the destination worksheet.
Any help would be deeply appreciated.
Tim
Trip Number is D1
Date is G1
Group is C5
Driver is B19
The offsets will reamin the same for all other cards and be indexed against the Trip Number cell that contains the "C". For each card to be copies, I need it to go to the next available line on the destination worksheet.
Any help would be deeply appreciated.
Tim